[Home] [Help]
6572: CURSOR cur_cancelled_MOLs IS
6573: SELECT mtrl.line_id
6574: , mtrl.uom_code
6575: FROM mtl_material_transactions_temp mmtt
6576: , mtl_txn_request_lines mtrl
6577: WHERE (mmtt.transaction_temp_id = p_transaction_temp_id
6578: -- shld add : and mmtt.mmtt.transaction_temp_id <> mmtt.parent_line_id
6579: OR mmtt.parent_line_id = p_transaction_temp_id)
6580: AND mtrl.line_id = mmtt.move_order_line_id
6651: AND NOT EXISTS ( SELECT 1
6652: FROM mtl_material_transactions_temp t1
6653: WHERE t1.parent_line_id = mmtt.transaction_temp_id);
6654:
6655: UPDATE mtl_txn_request_lines
6656: SET quantity_detailed =(quantity_detailed - l_deleted_mmtt_qty)
6657: , SECONDARY_QUANTITY_DETAILED = (SECONDARY_QUANTITY_DETAILED - l_deleted_mmtt_sec_qty)
6658: , line_status = DECODE(l_mmtt_count, 0, INV_GLOBALS.G_TO_STATUS_CLOSED, line_status)
6659: , last_update_date = SYSDATE
8076:
8077: --Fetch the UOM code of the MO line and lock the MO line
8078: SELECT uom_code, SECONDARY_UOM_CODE -- muom:sk
8079: INTO l_mol_uom, l_sec_mol_uom -- muom:sk
8080: FROM mtl_txn_request_lines
8081: WHERE line_id = l_mo_line_id
8082: FOR UPDATE;
8083:
8084: --Fetch the primary quantity for all MMTTs for this MO line
8124:
8125: --Now update quantity_detailed as quanity_delivered + sum(mmtt qty)
8126: --Bug#10120826 Now update secondary_quantity_detailed as secondary_quanity_delivered + l_sum_mmtt_sec_txn_qty
8127: -- muom:sk ssk: this takes care of full pick only..
8128: UPDATE mtl_txn_request_lines
8129: SET quantity_detailed = DECODE(l_fulfillment_base, 'S', l_sum_mmtt_qty, (NVL(quantity_delivered, 0) +l_mmtt_qty_in_mol_uom)),
8130: secondary_quantity_detailed = DECODE(l_fulfillment_base, 'S', l_mmtt_sec_qty_in_mol_uom, (NVL(secondary_quantity_delivered,0) + l_sum_mmtt_sec_txn_qty)),
8131: last_update_date = SYSDATE,
8132: last_updated_by = p_user_id
12602: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
12603: CURSOR c_cancelled_tasks IS
12604: --SELECT decode(mmtt.transaction_type_id, 35,'N',51,'N','Y')
12605: SELECT 'FAIL'
12606: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
12607: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
12608: AND mmtt.move_order_line_id = mol.line_id
12609: AND mol.line_status = inv_globals.g_to_status_cancel_by_source
12610: AND ROWNUM = 1;
13026: AND mmtt.transaction_temp_id = p_temp_id;
13027:
13028: CURSOR current_carton_grouping_cursor IS
13029: SELECT mol.carton_grouping_id
13030: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
13031: WHERE mmtt.transaction_temp_id = p_temp_id
13032: AND mmtt.organization_id = mol.organization_id
13033: AND mmtt.move_order_line_id = mol.line_id;
13034:
13033: AND mmtt.move_order_line_id = mol.line_id;
13034:
13035: CURSOR others_carton_grouping_cursor(p_lpn_id IN NUMBER) IS
13036: SELECT DISTINCT mol.carton_grouping_id
13037: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
13038: WHERE mmtt.transfer_lpn_id = p_lpn_id
13039: AND mmtt.organization_id = mol.organization_id
13040: AND mmtt.move_order_line_id = mol.line_id;
13041:
13436: INTO l_mmtt_mo_type
13437: , l_mmtt_txn_type_id
13438: , l_mmtt_wip_entity_type
13439: FROM mtl_txn_request_headers mtrh
13440: , mtl_txn_request_lines mtrl
13441: , mtl_material_transactions_temp mmtt
13442: WHERE mtrh.header_id = mtrl.header_id
13443: AND mtrl.line_id = mmtt.move_order_line_id
13444: AND mmtt.transaction_temp_id = p_temp_id;
13448: , mmtt.wip_entity_type
13449: INTO l_mo_type_in_lpn
13450: , l_wip_entity_type_in_lpn
13451: FROM mtl_txn_request_headers mtrh
13452: , mtl_txn_request_lines mtrl
13453: , mtl_material_transactions_temp mmtt
13454: WHERE mtrh.header_id = mtrl.header_id
13455: AND mtrl.line_id = mmtt.move_order_line_id
13456: AND mmtt.transfer_lpn_id = pick_to_lpn_rec.lpn_id