Friday, 5 January 2018

Query to get Operating units of the Inventory Organization in Cloud

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

No comments:

Post a Comment