Tuesday, April 29, 2014

Link between Operating Units and Inventory Organizations

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 inventory_organization_name,
         ood.organization_code inv_organization_code,
         ood.organization_id inv_organization_id, ood.chart_of_accounts_id
    FROM hr_operating_units hou, org_organization_definitions ood
   WHERE 1 = 1
     AND hou.organization_id = ood.operating_unit
     AND hou.organization_id = :operating_unit_id
ORDER BY hou.organization_id

No comments:

Post a Comment