[Home] [Help]
342: -- Bug 5231114: Added the condition on transaction_source_type_id and
343: -- transaction_action_id for the following combinations:13/12 and 4/27
344: CURSOR c_mmtt IS
345: SELECT transaction_temp_id
346: FROM mtl_material_transactions_temp
347: WHERE move_order_line_id = p_mol_id
348: AND ((transaction_source_type_id = 1 AND transaction_action_id = 27)
349: OR (transaction_source_type_id = 7 AND transaction_action_id = 12)
350: OR (transaction_source_type_id = 12 AND transaction_action_id = 27)
3860: , mtrl.quantity txn_qty
3861: , mtrl.quantity_detailed quantity_detailed
3862: , mtrl.quantity_delivered quantity_delivered
3863: FROM mtl_txn_request_lines mtrl
3864: , mtl_material_transactions_temp mmtt
3865: WHERE mtrl.organization_id = p_org_id
3866: AND nvl(mtrl.from_subinventory_code,'@$#_') = nvl(p_from_sub,'@$#_')
3867: AND nvl(mtrl.from_locator_id,-1) = nvl(p_from_locator_id,-1)
3868: AND ( nvl(mtrl.project_id,-1) = nvl(p_project_id,-1) OR p_project_id IS NULL )
3931: , mtrl.quantity txn_qty
3932: , mtrl.quantity_detailed quantity_detailed
3933: , mtrl.quantity_delivered quantity_delivered
3934: FROM mtl_txn_request_lines mtrl
3935: , mtl_material_transactions_temp mmtt
3936: WHERE mtrl.organization_id = p_org_id
3937: AND nvl(mtrl.from_subinventory_code,'@$#_') = nvl(p_from_sub,'@$#_')
3938: AND nvl(mtrl.from_locator_id,-1) = nvl(p_from_locator_id,-1)
3939: AND ( nvl(mtrl.project_id,-1) = nvl(p_project_id,-1) OR p_project_id IS NULL )
4304:
4305: --{{
4306: --After TRANSFER and DELIVER, make sure MMT for the transaction are
4307: --updated with the correct values }}
4308: UPDATE mtl_material_transactions_temp
4309: SET rcv_transaction_id = l_transaction_id
4310: , transfer_to_location = Decode(transfer_to_location,NULL,transfer_to_location,p_locator_id)
4311: , transfer_subinventory = Decode(transfer_to_location,NULL,transfer_subinventory,p_subinventory)
4312: , locator_id = Decode(transfer_to_location,NULL,p_locator_id,locator_id)
5009: FROM dual
5010: WHERE exists
5011: (SELECT 1
5012: FROM wms_dispatched_tasks wdt
5013: , mtl_material_transactions_temp mmtt
5014: WHERE mmtt.move_order_line_id = l_transfer_mol_rec.line_id
5015: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
5016: AND wdt.status IN (3, 4) -- dispached or loaded
5017: AND wdt.task_type = 2 -- putaway
5410: FROM dual
5411: WHERE exists
5412: (SELECT 1
5413: FROM wms_dispatched_tasks wdt
5414: , mtl_material_transactions_temp mmtt
5415: WHERE mmtt.move_order_line_id = l_transfer_mol_rec.line_id
5416: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
5417: AND wdt.status IN (3, 4) -- dispached or loaded
5418: AND wdt.task_type = 2 -- putaway
6088: --
6089: -- UPDATE THE MOVE ORDER LINE HERE
6090: --
6091: IF (p_mmtt_temp_id IS NOT NULL) THEN
6092: UPDATE mtl_material_transactions_temp
6093: SET move_order_line_id = l_transfer_mol_rec.line_id
6094: WHERE transaction_temp_id = p_mmtt_temp_id;
6095:
6096: l_qty_detailed := l_mol_res_in(1).quantity;
7157: FROM dual
7158: WHERE exists
7159: (SELECT 1
7160: FROM wms_dispatched_tasks wdt
7161: , mtl_material_transactions_temp mmtt
7162: WHERE mmtt.move_order_line_id = l_transfer_mol_rec.line_id
7163: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
7164: AND wdt.status IN (3, 4) -- dispached or loaded
7165: AND wdt.task_type = 2 -- putaway
11183: , Nvl(mmtt.transaction_quantity,mtrl.quantity-Nvl(mtrl.quantity_delivered,0)) txn_qty
11184: , Nvl(mmtt.transaction_uom,mtrl.uom_code) txn_uom_code
11185: , Nvl(mmtt.secondary_transaction_quantity
11186: , mtrl.secondary_quantity-Nvl(mtrl.secondary_quantity_delivered,0)) sec_qty --OPM Convergence
11187: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
11188: WHERE mmtt.move_order_line_id (+)= mtrl.line_id
11189: AND mtrl.lpn_id = v_lpn_id
11190: AND mtrl.line_status = 7
11191: AND mtrl.quantity-Nvl(mtrl.quantity_delivered,0) > 0