Tuesday, 13 January 2015

Query to find locators in a subinventory:

SELECT   il.inventory_location_id,
         il.organization_id,
         il.subinventory_code,
         il.description,
         il.physical_location_id,
         il.pick_uom_code,
         il.dimension_uom_code,
         il.LENGTH,
         il.width,
         il.height,
         il.locator_status,
         il.status_id,
         l.meaning
  FROM   mfg_lookups l, mtl_item_locations il
 WHERE       organization_id = 207
         AND subinventory_code = 'Stores'
         AND il.inventory_location_type = l.lookup_code(+)
         AND l.lookup_type(+) = 'MTL_LOCATOR_TYPES'

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