INV OU PL LE
Below query finds out all the Inventory Organization and corresponding Operating Unit, Ledger and Legal Entity.
Select a.organization_id, a.organization_code, a.organization_name,
a.operating_unit, b.name OU, a.set_of_books_id,d.name LEDGER,
a.legal_entity,c.name LE_NAME
From apps. ORG_ORGANIZATION_DEFINITIONS a,
apps. HR_OPERATING_UNITS b,
apps. xle_entity_profiles c,
apps. gl_ledgers d
Where a.operating_unit=b.organization_id
AND c.legal_entity_id=a.legal_entity
AND d.ledger_id=a.set_of_books_id
Comments
Select a.organization_id, a.organization_code, a.organization_name, e.Location_code,
e.country, a.operating_unit, b.name OU, a.set_of_books_id,d.name LEDGER,
a.legal_entity,c.name LE_NAME
From apps. ORG_ORGANIZATION_DEFINITIONS a,
apps. HR_OPERATING_UNITS b,
apps. xle_entity_profiles c,
apps. gl_ledgers d,
apps. HR_LOCATIONS_ALL e
Where a.operating_unit=b.organization_id
AND c.legal_entity_id=a.legal_entity
AND d.ledger_id=a.set_of_books_id
AND e.inventory_organization_id=a.organization_id
The above query will not work .
there are no table available 1)xle_entity_profiles 2)gl_ledgers
Select a.organization_id, a.organization_code, a.organization_name, e.Location_code,
e.country, a.operating_unit, b.name OU, a.set_of_books_id,d.name LEDGER,
a.legal_entity
From apps. ORG_ORGANIZATION_DEFINITIONS a,
apps. HR_OPERATING_UNITS b,
--apps. xle_entity_profiles c,
apps. GL_SETS_OF_BOOKS_V d,
apps. HR_LOCATIONS_ALL e
Where a.operating_unit=b.organization_id
--AND c.legal_entity_id=a.legal_entity
AND d.set_of_books_id=a.set_of_books_id
AND e.inventory_organization_id=a.organization_id
Post new comment