SELECT hou.NAME operating_unit_name,
hou.short_code,
hou.organization_id operating_unit_id,
hou.set_of_books_id,
hou.business_group_id,
ood.organization_name ood.organization_code Inv_organization_code,
ood.organization_id Inv_organization_id,
FROM hr_operating_units hou,
inv_organization_definitions_v ood
WHERE 1 = 1
AND hou.organization_id = ood.BUSINESS_UNIT_ID
ORDER BY hou.organization_id ASC
hou.short_code,
hou.organization_id operating_unit_id,
hou.set_of_books_id,
hou.business_group_id,
ood.organization_name ood.organization_code Inv_organization_code,
ood.organization_id Inv_organization_id,
FROM hr_operating_units hou,
inv_organization_definitions_v ood
WHERE 1 = 1
AND hou.organization_id = ood.BUSINESS_UNIT_ID
ORDER BY hou.organization_id ASC
No comments:
Post a Comment