Tuesday 13 January 2015

Query to find inventory organizations for an operating unit :

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