Monday, October 23, 2017

Query to get Legal Entity, Operating Unit, Inv Organization Details in Oracle Apps

SELECT xep.name legal_entity_name,
       gl.name ledger_name,
       ou.NAME operating_unit_name,
       ou.short_code,
       ou.organization_id operating_unit_id,
       ou.set_of_books_id,
       ou.business_group_id,
       ood.organization_name inventory_organization_name,
       ood.organization_code Inv_organization_code,
       ood.organization_id Inv_organization_id,
       ood.chart_of_accounts_id
FROM hr_operating_units ou,
     org_organization_definitions ood,
     gl_ledgers gl,
     xle_entity_profiles xep
WHERE ou.organization_id(+) = ood.operating_unit
  and ood.set_of_books_id = gl.ledger_id
  and ood.legal_entity = xep.legal_entity_id
ORDER BY ou.organization_id

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)