Query to find inventory organization in oracle apps

Query to find inventory organization in oracle apps

In this post , We will be discuss about Query to find inventory organization in oracle apps. This query will help to extract the inventory organization details in oracle apps. We will get the list of inventory organizations in oracle apps using this sql query. This is one of the important sql query to extract the list of Query to find inventory organization in oracle apps. Please find below the detail sql Query to find inventory organization in oracle apps.

Query to find inventory organization in oracle apps

Important Tables used by Query to find inventory organization in oracle apps

1.hr_operating_units

2.org_organization_definitions

Detail sql Query to find inventory organization in oracle apps

  SELECT hou.NAME operating_unit_name,

         hou.short_code,

         hou.organization_id operating_unit_id,

         hou.set_of_books_id,

         ood.organization_name inventory_organization_name,

         ood.organization_code Inv_organization_code,

         ood.chart_of_accounts_id

    FROM hr_operating_units hou,

    org_organization_definitions ood

   WHERE 1 = 1 AND hou.organization_id = ood.operating_unit

ORDER BY hou.organization_id

Query to find inventory organization in oracle apps