APPS.WMS_ATF_DESTINATION_LPN dependencies on WMS_OP_PLAN_INSTANCES

Line 188: from wms_op_plan_instances wopi, -- after review on 07/30/03, replaced wms_op_plans_b table with wms_op_plan_instances.

184: wopd.lpn_mtrl_grp_rule_id,
185: wopd.operation_type,
186: nvl(wopd.is_in_inventory, 'N'),
187: mmtt.organization_id
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

Line 222: wms_op_plan_instances wopi,

218: select wlpn.outermost_lpn_id
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

Line 261: wms_op_plan_instances wopi,

257: select wlpn.outermost_lpn_id
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

Line 298: wms_op_plan_instances wopi,

294: cursor c_lpn_active_wozone_witem is
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

Line 332: wms_op_plan_instances wopi,

328: cursor c_lpn_active_wozone_woitem is
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

Line 363: from wms_op_plan_instances_hist wopih,

359: --
360: --
361: cursor c_lpn_comp_wzone_witem is
362: select wlpn.outermost_lpn_id
363: from wms_op_plan_instances_hist wopih,
364: wms_op_opertn_instances_hist wooih,
365: wms_zone_locators wzl,
366: wms_dispatched_tasks_history wdth,
367: wms_license_plate_numbers wlpn

Line 405: from wms_op_plan_instances_hist wopih,

401: --
402: --
403: cursor c_lpn_comp_wzone_woitem is
404: select wlpn.outermost_lpn_id
405: from wms_op_plan_instances_hist wopih,
406: wms_op_opertn_instances_hist wooih,
407: wms_zone_locators wzl,
408: wms_dispatched_tasks_history wdth,
409: wms_license_plate_numbers wlpn

Line 446: from wms_op_plan_instances_hist wopih,

442: --
443: --
444: cursor c_lpn_comp_wozone_witem is
445: select wlpn.outermost_lpn_id
446: from wms_op_plan_instances_hist wopih,
447: wms_op_opertn_instances_hist wooih,
448: wms_dispatched_tasks_history wdth,
449: wms_license_plate_numbers wlpn
450: where wlpn.subinventory_code = wdth.dest_subinventory_code

Line 485: from wms_op_plan_instances_hist wopih,

481: --
482: --
483: cursor c_lpn_comp_wozone_woitem is
484: select wlpn.outermost_lpn_id
485: from wms_op_plan_instances_hist wopih,
486: wms_op_opertn_instances_hist wooih,
487: wms_dispatched_tasks_history wdth,
488: wms_license_plate_numbers wlpn
489: where wlpn.subinventory_code = wdth.dest_subinventory_code