APPS.WSH_DEL_OI_CORE dependencies on MTL_SECONDARY_INVENTORIES

Line 149: from mtl_secondary_inventories

145: X_description varchar2(50);
146:
147: cursor valid_sub is
148: select description
149: from mtl_secondary_inventories
150: where organization_id = X_warehouse_id
151: and quantity_tracked = 1
152: and trunc(sysdate) <= nvl( disable_date, trunc(sysdate) )
153: and secondary_inventory_name = x_subinventory;

Line 158: , mtl_secondary_inventories mtlsub

154:
155: cursor valid_sub_restricted is
156: select mtlsub.description
157: from mtl_item_sub_inventories mtlisi
158: , mtl_secondary_inventories mtlsub
159: where mtlisi.organization_id = X_warehouse_id
160: and mtlisi.inventory_item_id = X_item_id
161: and mtlsub.organization_id = X_warehouse_id
162: and mtlsub.secondary_inventory_name = mtlisi.secondary_inventory

Line 220: mtl_secondary_inventories mtlsub

216: declare
217: cursor default_sub is
218: select mtlsub.secondary_inventory_name
219: from mtl_item_sub_defaults mtlisd,
220: mtl_secondary_inventories mtlsub
221: where mtlisd.inventory_item_id = X_item_id
222: and mtlisd.organization_id = X_warehouse_id
223: and mtlisd.default_type = 1
224: and mtlsub.organization_id = mtlisd.organization_id

Line 285: , mtl_secondary_inventories mtlsin

281: 1, 'N', 2, 'Y', 3, 'D', 'N' ),
282: 'N' )
283: , DECODE( mtlsis.restrict_locators_code, 1, 'Y', 'N' )
284: from mtl_parameters mtlpar
285: , mtl_secondary_inventories mtlsin
286: , mtl_system_items mtlsis
287: where mtlpar.organization_id = X_warehouse_id
288: and mtlsin.organization_id = mtlpar.organization_id
289: and mtlsin.secondary_inventory_name = X_subinventory