Wednesday, May 15, 2013

Find Master Organization for Organization Oracle Apps

Master Organization can be found in different ways. Simple way is to use

SELECT * FROM OE_SYSTEM_PARAMETERS;

Make sure you initialize org_id of the operating unit so that parent organization can be derived specific to that Org.

set-org-context-in-oracle-apps-11i/R12

Query to find Organization Structure Oracle Apps

Query to find Organization Structure in Oracle Apps


SELECT   ood.operating_unit, hou.NAME, ood.organization_id,       
         ood.organization_name,       
         (SELECT organization_code       
            FROM mtl_parameters mp       
           WHERE mp.organization_id = ood.organization_id) inventory_org_code       
    FROM hr_operating_units hou, org_organization_definitions ood       
   WHERE hou.organization_id = ood.operating_unit
ORDER BY ood.operating_unit, ood.organization_id;