Simple Query to fetch Subinventory & Stock Locator Information

SELECT

     substr(matsub.secondary_inventory_name,1,10) "SubInv",

     substr(matsub.description,1,20) "Descripton",

     substr(matloc.description,1,20) "Locator",

         substr(matloc.inventory_location_type,1,1) "Locator Type",

     substr(matloc.inventory_location_ID,1,4) "Locator ID"

FROM

     mtl_secondary_inventories matsub,

     mtl_item_locations matloc

WHERE

     matsub.secondary_inventory_name LIKE ‘&XX_SUBINVENTORY%' AND

     matsub.organization_id = 207 AND

     matloc.organization_id = 207 AND

     matsub.secondary_inventory_name = matloc.subinventory_code

Thanks & Regards,

S.Grace Paul Regan