[Home] [Help]
97:
98: IF l_lpn_context = 8 THEN -- Packing Context: LPN1 has been loaded
99: SELECT wda.delivery_id
100: INTO l_delivery_id
101: FROM mtl_material_transactions_temp mmtt,
102: wsh_delivery_details_ob_grp_v wdd,
103: wsh_delivery_assignments_v wda
104: WHERE mmtt.transfer_lpn_id = p_lpn_id
105: AND mmtt.transaction_action_id = 28
119: --START--Added for bug 10139672
120: --In case of bulk pick with multiple deliveries, the MMTT record will be stamped with "To LPN" whose context
121: --will be 5 and it will be linked with a delivery
122: select count(wda.delivery_id) into l_no_of_deliveries
123: FROM mtl_material_transactions_temp mmtt,
124: wsh_delivery_details_ob_grp_v wdd,
125: wsh_delivery_assignments_v wda
126: WHERE mmtt.transfer_lpn_id = p_lpn_id
127: AND mmtt.transaction_action_id = 28
137: IF l_no_of_deliveries > 0 THEN
138:
139: SELECT wda.delivery_id
140: INTO l_delivery_id
141: FROM mtl_material_transactions_temp mmtt,
142: wsh_delivery_details_ob_grp_v wdd,
143: wsh_delivery_assignments_v wda
144: WHERE mmtt.transfer_lpn_id = p_lpn_id
145: AND mmtt.transaction_action_id = 28
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
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
272: START WITH wlpn.lpn_id = p_lpn_id