APPS.WMS_MDC_PVT dependencies on WMS_OP_PLAN_DETAILS

Line 225: FROM wms_op_plan_details wopd, mtl_material_transactions_temp mmtt

221: IF p_lpn_context = 8 THEN -- Packing Context: LPN1 has been loaded
222: BEGIN
223: SELECT 2 -- 1=AD, 2=WD
224: INTO l_consolidation_method_id -- 1=AD, 2=WD
225: FROM wms_op_plan_details wopd, mtl_material_transactions_temp mmtt
226: WHERE (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
227: AND mmtt.transaction_action_id = 28
228: AND mmtt.transaction_source_type_id IN (2, 8)
229: AND mmtt.operation_plan_id = wopd.operation_plan_id

Line 249: FROM wms_op_plan_details wopd, wms_dispatched_tasks_history wdth

245: -- 12:Loaded to stage move Context
246: BEGIN
247: SELECT 2 -- 1=AD, 2=WD
248: INTO l_consolidation_method_id -- 1=AD, 2=WD
249: FROM wms_op_plan_details wopd, wms_dispatched_tasks_history wdth
250: WHERE wdth.transfer_lpn_id = p_lpn_id
251: AND wdth.operation_plan_id = wopd.operation_plan_id
252: AND wopd.consolidation_method_id = 2 --WD
253: AND wopd.operation_type = 2 -- Drop

Line 267: FROM wms_op_plan_details wopd,

263: ELSIF p_lpn_context = 3 THEN
264: BEGIN
265: SELECT 2
266: INTO l_consolidation_method_id
267: FROM wms_op_plan_details wopd,
268: mtl_material_transactions_temp mmtt,
269: mtl_txn_request_lines mtrl
270: WHERE mtrl.lpn_id IN (SELECT wlpn.lpn_id
271: FROM wms_license_plate_numbers wlpn