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
/

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete