APPS.WMS_MDC_PVT dependencies on WMS_OP_PLAN_DETAILS

Line 188: FROM wms_op_plan_details wopd, mtl_material_transactions_temp mmtt

184: IF p_lpn_context = 8 THEN -- Packing Context: LPN1 has been loaded
185: BEGIN
186: SELECT 2 -- 1=AD, 2=WD
187: INTO l_consolidation_method_id -- 1=AD, 2=WD
188: FROM wms_op_plan_details wopd, mtl_material_transactions_temp mmtt
189: WHERE (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
190: AND mmtt.transaction_action_id = 28
191: AND mmtt.transaction_source_type_id IN (2, 8)
192: AND mmtt.operation_plan_id = wopd.operation_plan_id

Line 212: FROM wms_op_plan_details wopd, wms_dispatched_tasks_history wdth

208: -- 12:Loaded to stage move Context
209: BEGIN
210: SELECT 2 -- 1=AD, 2=WD
211: INTO l_consolidation_method_id -- 1=AD, 2=WD
212: FROM wms_op_plan_details wopd, wms_dispatched_tasks_history wdth
213: WHERE wdth.transfer_lpn_id = p_lpn_id
214: AND wdth.operation_plan_id = wopd.operation_plan_id
215: AND wopd.consolidation_method_id = 2 --WD
216: AND wopd.operation_type = 2 -- Drop

Line 230: FROM wms_op_plan_details wopd,

226: ELSIF p_lpn_context = 3 THEN
227: BEGIN
228: SELECT 2
229: INTO l_consolidation_method_id
230: FROM wms_op_plan_details wopd,
231: mtl_material_transactions_temp mmtt,
232: mtl_txn_request_lines mtrl
233: WHERE mtrl.lpn_id IN (SELECT wlpn.lpn_id
234: FROM wms_license_plate_numbers wlpn