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

Query to get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...