APPS.WMS_ATF_DESTINATION_LPN dependencies on WMS_OP_OPERATION_INSTANCES

Line 192: wms_op_operation_instances wooi -- Added after review on 07/30/03

188: from wms_op_plan_instances wopi, -- after review on 07/30/03, replaced wms_op_plans_b table with wms_op_plan_instances.
189: wms_op_plan_details wopd,
190: -- wms_zones_b wzb, -- Removed after Code Review on Sept 11th 2003.
191: mtl_material_transactions_temp mmtt,
192: wms_op_operation_instances wooi -- Added after review on 07/30/03
193: where mmtt.organization_id = wopi.organization_id
194: -- @@@ Commented after Code Review on Sept 11th 2003.
195: -- and wzb.zone_id(+) = wopd.pre_specified_zone_id
196: and wopd.operation_plan_detail_id = wooi.operation_plan_detail_id -- Added after review on 07/30/03

Line 223: wms_op_operation_instances wooi,

219: from wms_license_plate_numbers wlpn,
220: mtl_material_transactions_temp mmtt,
221: wms_zone_locators wzl,
222: wms_op_plan_instances wopi,
223: wms_op_operation_instances wooi,
224: wms_op_operation_instances wooi2
225: where wlpn.lpn_context = decode(l_is_in_inventory, 'Y', 1, 3)
226: and wlpn.organization_id = l_organization_id
227: and wlpn.subinventory_code = p_subinventory_code -- new

Line 224: wms_op_operation_instances wooi2

220: mtl_material_transactions_temp mmtt,
221: wms_zone_locators wzl,
222: wms_op_plan_instances wopi,
223: wms_op_operation_instances wooi,
224: wms_op_operation_instances wooi2
225: where wlpn.lpn_context = decode(l_is_in_inventory, 'Y', 1, 3)
226: and wlpn.organization_id = l_organization_id
227: and wlpn.subinventory_code = p_subinventory_code -- new
228: and wlpn.locator_id = p_locator_id -- new

Line 262: wms_op_operation_instances wooi,

258: from mtl_material_transactions_temp mmtt,
259: wms_license_plate_numbers wlpn,
260: wms_zone_locators wzl,
261: wms_op_plan_instances wopi,
262: wms_op_operation_instances wooi,
263: wms_op_operation_instances wooi2
264: where wlpn.lpn_context = decode(l_is_in_inventory, 'Y', 1, 3)
265: and wlpn.organization_id = l_organization_id
266: and wlpn.subinventory_code = p_subinventory_code -- new

Line 263: wms_op_operation_instances wooi2

259: wms_license_plate_numbers wlpn,
260: wms_zone_locators wzl,
261: wms_op_plan_instances wopi,
262: wms_op_operation_instances wooi,
263: wms_op_operation_instances wooi2
264: where wlpn.lpn_context = decode(l_is_in_inventory, 'Y', 1, 3)
265: and wlpn.organization_id = l_organization_id
266: and wlpn.subinventory_code = p_subinventory_code -- new
267: and wlpn.locator_id = p_locator_id -- new

Line 299: wms_op_operation_instances wooi,

295: select wlpn.outermost_lpn_id
296: from mtl_material_transactions_temp mmtt,
297: wms_license_plate_numbers wlpn,
298: wms_op_plan_instances wopi,
299: wms_op_operation_instances wooi,
300: wms_op_operation_instances wooi2
301: where wlpn.lpn_context = decode(l_is_in_inventory, 'Y', 1, 3)
302: and wlpn.organization_id = l_organization_id
303: and wlpn.subinventory_code = p_subinventory_code -- new

Line 300: wms_op_operation_instances wooi2

296: from mtl_material_transactions_temp mmtt,
297: wms_license_plate_numbers wlpn,
298: wms_op_plan_instances wopi,
299: wms_op_operation_instances wooi,
300: wms_op_operation_instances wooi2
301: where wlpn.lpn_context = decode(l_is_in_inventory, 'Y', 1, 3)
302: and wlpn.organization_id = l_organization_id
303: and wlpn.subinventory_code = p_subinventory_code -- new
304: and wlpn.locator_id = p_locator_id -- new

Line 333: wms_op_operation_instances wooi,

329: select wlpn.outermost_lpn_id
330: from mtl_material_transactions_temp mmtt,
331: wms_license_plate_numbers wlpn,
332: wms_op_plan_instances wopi,
333: wms_op_operation_instances wooi,
334: wms_op_operation_instances wooi2
335: where wlpn.lpn_context = decode(l_is_in_inventory, 'Y', 1, 3)
336: and wlpn.organization_id = l_organization_id
337: and wlpn.subinventory_code = p_subinventory_code -- new

Line 334: wms_op_operation_instances wooi2

330: from mtl_material_transactions_temp mmtt,
331: wms_license_plate_numbers wlpn,
332: wms_op_plan_instances wopi,
333: wms_op_operation_instances wooi,
334: wms_op_operation_instances wooi2
335: where wlpn.lpn_context = decode(l_is_in_inventory, 'Y', 1, 3)
336: and wlpn.organization_id = l_organization_id
337: and wlpn.subinventory_code = p_subinventory_code -- new
338: and wlpn.locator_id = p_locator_id -- new