Tuesday, 13 January 2015

Find items restricted to a subinventory :

SELECT   isb.inventory_item_id,
           isb.organization_id,
           si.segment1 item,
           isb.secondary_inventory,
           isb.primary_subinventory_flag,
           isb.picking_order,
           isb.min_minmax_quantity,
           isb.max_minmax_quantity,
           isb.inventory_planning_code,
           isb.fixed_lot_multiple,
           isb.minimum_order_quantity,
           isb.maximum_order_quantity,
           isb.source_type,
           isb.source_organization_id,
           isb.source_subinventory
    FROM   mtl_item_sub_inventories isb, mtl_system_items si
   WHERE       isb.secondary_inventory = 'Stores'
           AND isb.inventory_item_id = si.inventory_item_id
           AND isb.organization_id = si.organization_id
ORDER BY   1

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