Tuesday, 13 January 2015

Query to find subinventories for an inv organization :

SELECT   secondary_inventory_name subinventory,
           description,
           subinventory_type,
           organization_id,
           asset_inventory,
           quantity_tracked,
           inventory_atp_code,
           availability_type,
           reservable_type,
           locator_type,
           picking_order,
           dropping_order,
           location_id,
           status_id
    FROM   mtl_secondary_inventories
   WHERE   organization_id = 207
ORDER BY   subinventory
/

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