Subinventory table in oracle apps

Subinventory table in oracle apps

In this post , We will discuss about mtl_secondary_inventories table in oracle apps.These two tables helps to store the sub inventory information’s in oracle apps.

 subinventory table in oracle apps

 

mtl_item_sub_inventories

mtl_secondary_inventories

 

Sql Query Using subinventory table in oracle apps.

 

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 a1,

     mtl_item_locations a2

WHERE

     a1.secondary_inventory_name LIKE '&XX_SUBINVENTORY%'

    AND a1.organization_id = 207

    AND a2.organization_id = 207

    AND a1.secondary_inventory_name = a2.subinventory_code;