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
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