APPS.WSH_DEL_OI_CORE dependencies on MTL_SYSTEM_ITEMS

Line 97: from mtl_system_items msi

93: decode(msi.lot_control_code,2,'Y',3,'Y','N'),
94: decode(msi.serial_number_control_code,
95: -- 2=Predefined serial# 5=Dynamic at inv. receipt 6=Dynamic at sales issue
96: 2,'Y', 5,'Y', 6,decode(X_order_category,'P','N','D'),'N')
97: from mtl_system_items msi
98: where msi.inventory_item_id = X_item_id
99: and msi.organization_id = X_warehouse_id;
100: begin
101: open control_codes;

Line 286: , mtl_system_items mtlsis

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
290: and mtlsis.organization_id = mtlpar.organization_id