APPS.WMA_SPECIAL_LOVS dependencies on MTL_SECONDARY_INVENTORIES

Line 28: from mtl_secondary_inventories

24: -- item is not restricted to subinventories
25: OPEN subinventories FOR
26: select secondary_inventory_name,
27: locator_type
28: from mtl_secondary_inventories
29: where organization_id = orgID
30: and secondary_inventory_name like invName || '%'
31: and secondary_inventory_name <> 'AX_INTRANS'
32: and inv_material_status_grp.is_status_applicable(

Line 52: mtl_secondary_inventories msi

48: OPEN subinventories FOR
49: select misi.secondary_inventory,
50: msi.locator_type
51: from mtl_item_sub_inventories misi,
52: mtl_secondary_inventories msi
53: where misi.secondary_inventory = msi.secondary_inventory_name
54: and misi.organization_id = msi.organization_id
55: and misi.inventory_item_id = itemID
56: and misi.organization_id = orgID

Line 105: from mtl_secondary_inventories

101:
102: -- not 1, 2, 3, so it must be subinv level control
103: select locator_type
104: into subinvLevelCtl
105: from mtl_secondary_inventories
106: where organization_id = orgID
107: and secondary_inventory_name = subinv;
108:
109: if ( subinvLevelCtl < 4 ) then -- subinv level