SELECT organization_id
, organization_code
, organization_name,
(SELECT location_id
FROM hr_all_organization_units ou
WHERE od.organization_id = ou.organization_id) location_id
, user_definition_enable_date
, disable_date
, chart_of_accounts_id
, inventory_enabled_flag
, operating_unit
, legal_entity
, set_of_books_id
, business_group_id
FROM org_organization_definitions od
WHERE operating_unit = 204
ORDER BY organization_code
No comments :
Post a Comment