APPS.WMS_MDC_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 100: FROM mtl_material_transactions_temp mmtt,

96:
97: IF l_lpn_context = 8 THEN -- Packing Context: LPN1 has been loaded
98: SELECT wda.delivery_id
99: INTO l_delivery_id
100: FROM mtl_material_transactions_temp mmtt,
101: wsh_delivery_details_ob_grp_v wdd,
102: wsh_delivery_assignments_v wda
103: WHERE mmtt.transfer_lpn_id = p_lpn_id
104: AND mmtt.transaction_action_id = 28

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 231: mtl_material_transactions_temp mmtt,

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
235: START WITH wlpn.lpn_id = p_lpn_id