DBA Data[Home] [Help]

APPS.CSP_MO_MTLTXNS_UTIL dependencies on MTL_MATERIAL_TRANSACTIONS

Line 124: FROM mtl_material_transactions_temp

120: ELSE
121: -- validate whether the move_order_line_id exists in the mmtt table
122: BEGIN
123: SELECT transaction_temp_id into l_check_existence
124: FROM mtl_material_transactions_temp
125: WHERE move_order_line_id = p_move_order_line_id
126: AND organization_id = p_organization_id;
127: EXCEPTION
128: WHEN NO_DATA_FOUND THEN

Line 140: fnd_message.set_token('TABLE', 'mtl_material_transactions_temp', FALSE);

136: WHEN OTHERS THEN
137: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
138: fnd_message.set_token('ERR_FIELD', 'p_move_order_line_id', FALSE);
139: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
140: fnd_message.set_token('TABLE', 'mtl_material_transactions_temp', FALSE);
141: FND_MSG_PUB.ADD;
142: RAISE EXCP_USER_DEFINED;
143: END;
144:

Line 597: FROM mtl_material_transactions_temp

593: -- ADDED by phegde 02/23
594: WMS_TASK_TYPE ,
595: PARENT_LINE_ID
596: -- SOURCE_LOT_NUMBER
597: FROM mtl_material_transactions_temp
598: WHERE transaction_temp_id = l_transaction_temp_id
599: AND organization_id = p_organization_id;
600: CURSOR l_Get_Shipped_Received_Qty IS
601: SELECT nvl(quantity_shipped, 0), nvl(quantity_received, 0)

Line 610: SELECT mtl_material_transactions_s.nextval

606: SELECT distinct header_id
607: FROM csp_moveorder_lines
608: WHERE line_id = l_line_id;
609: CURSOR l_Get_txn_header_id_csr IS
610: SELECT mtl_material_transactions_s.nextval
611: FROM dual;
612: CURSOR l_Get_Packlist_Status_Csr(l_packlist_header_id NUMBER) IS
613: SELECT packlist_status
614: FROM csp_packlist_headers

Line 625: SELECT MTL_MATERIAL_TRANSACTIONS_S.nextval FROM dual;

621: AND organization_id = p_organization_id
622: AND period_close_date is null
623: AND nvl(open_flag,'Y') = 'Y';
624: CURSOR l_Get_Serial_Temp_id_Csr IS
625: SELECT MTL_MATERIAL_TRANSACTIONS_S.nextval FROM dual;
626:
627: CURSOR l_Get_Packlist_Csr (l_packlist_header_id NUMBER) Is
628: SELECT
629: PACKLIST_HEADER_ID ,

Line 976: -- Prepare to create the mtl_material_transactions_temp record

972: -- the user may want to receive SN5 which is tied to the deleted temp_id. What we need to do is to reconstruct
973: -- the temp record before proceeding further.
974: CLOSE l_ml_records;
975:
976: -- Prepare to create the mtl_material_transactions_temp record
977: l_csp_mtltxn_rec.transaction_temp_id := p_transaction_temp_id;
978: l_csp_mtltxn_rec.organization_id := p_organization_id;
979:
980: SELECT line_id, inventory_item_id, to_subinventory_code, to_locator_id, uom_code

Line 2411: FROM mtl_material_transactions_temp

2407: -- ADDED by phegde 02/23
2408: WMS_TASK_TYPE ,
2409: PARENT_LINE_ID
2410: -- SOURCE_LOT_NUMBER
2411: FROM mtl_material_transactions_temp
2412: WHERE transaction_temp_id = p_transaction_temp_id;
2413: BEGIN
2414: OPEN l_ml_records;
2415: FETCH l_ml_records INTO l_csp_mtltxn_rec;

Line 2430: delete from mtl_material_transactions_temp

2426:
2427: delete from mtl_transaction_lots_temp
2428: where transaction_temp_id = l_temp_id_to_be_processed;
2429:
2430: delete from mtl_material_transactions_temp
2431: where transaction_temp_id = l_temp_id_to_be_processed;
2432: -- case 2: if lot control and serial control, delete the record in the mmtt table, the mtlt table and the msnt table
2433: Elsif nvl(l_csp_mtltxn_rec.item_lot_control_code, 1) <> 1 And
2434: nvl(l_csp_mtltxn_rec.item_serial_control_code, 1) in (2, 5) Then

Line 2462: delete from mtl_material_transactions_temp

2458:
2459: delete from mtl_transaction_lots_temp
2460: where transaction_temp_id = l_temp_id_to_be_processed;
2461:
2462: delete from mtl_material_transactions_temp
2463: where transaction_temp_id = l_temp_id_to_be_processed;
2464: -- case 3: if serial control, delete the record in the mmtt table and the msnt table
2465: Elsif nvl(l_csp_mtltxn_rec.item_lot_control_code, 1) = 1 And
2466: nvl(l_csp_mtltxn_rec.item_serial_control_code, 1) in (2,5) Then

Line 2471: delete from mtl_material_transactions_temp

2467:
2468: delete from mtl_serial_numbers_temp
2469: where transaction_temp_id = l_temp_id_to_be_processed;
2470:
2471: delete from mtl_material_transactions_temp
2472: where transaction_temp_id = l_temp_id_to_be_processed;
2473: Else
2474: -- case 4: neither serial control nor lot control, delete the record in the mmtt table
2475: delete from mtl_material_transactions_temp

Line 2475: delete from mtl_material_transactions_temp

2471: delete from mtl_material_transactions_temp
2472: where transaction_temp_id = l_temp_id_to_be_processed;
2473: Else
2474: -- case 4: neither serial control nor lot control, delete the record in the mmtt table
2475: delete from mtl_material_transactions_temp
2476: where transaction_temp_id = l_temp_id_to_be_processed;
2477: End If;
2478:
2479: Return fnd_api.g_true;

Line 2533: -- Update the move_order_line_id in the mtl_material_transactions so that the transaction record

2529: Begin
2530: LOOP
2531: FETCH l_Get_Interface_Csr INTO l_Interface_Rec;
2532: EXIT WHEN l_Get_Interface_Csr%NOTFOUND;
2533: -- Update the move_order_line_id in the mtl_material_transactions so that the transaction record
2534: -- has track-back history to the move order.
2535: -- We need to do this post transaction update because there is no such column move_order_line_id in the
2536: -- mtl_transactions_interface table.
2537: update mtl_material_transactions

Line 2537: update mtl_material_transactions

2533: -- Update the move_order_line_id in the mtl_material_transactions so that the transaction record
2534: -- has track-back history to the move order.
2535: -- We need to do this post transaction update because there is no such column move_order_line_id in the
2536: -- mtl_transactions_interface table.
2537: update mtl_material_transactions
2538: set move_order_line_id = l_Interface_Rec.trx_source_line_id
2539: where transaction_source_id = l_Interface_Rec.transaction_source_id
2540: and trx_source_line_id = l_Interface_Rec.trx_source_line_id
2541: and organization_id = l_Interface_Rec.organization_id;

Line 2601: SELECT mtl_material_transactions_s.nextval

2597: --l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;
2598: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
2599: EXCP_USER_DEFINED EXCEPTION;
2600: Cursor l_Get_txn_header_id_csr IS
2601: SELECT mtl_material_transactions_s.nextval
2602: FROM dual;
2603:
2604: CURSOR l_ml_records IS
2605: SELECT

Line 2798: FROM mtl_material_transactions_temp

2794: -- ADDED by phegde 02/23
2795: WMS_TASK_TYPE ,
2796: PARENT_LINE_ID
2797: -- SOURCE_LOT_NUMBER
2798: FROM mtl_material_transactions_temp
2799: WHERE transaction_temp_id = p_transaction_temp_id;
2800:
2801: CURSOR l_Get_Mtlt IS
2802: SELECT * FROM mtl_transaction_lots_temp

Line 2965: CURSOR l_Get_Serial_Temp_id_Csr IS SELECT MTL_MATERIAL_TRANSACTIONS_S.nextval FROM dual;

2961: SELECT * FROM mtl_transaction_lots_temp
2962: WHERE transaction_temp_id = p_old_transaction_temp_id
2963: AND lot_number = p_lot_number
2964: ORDER BY TRANSACTION_QUANTITY DESC;
2965: CURSOR l_Get_Serial_Temp_id_Csr IS SELECT MTL_MATERIAL_TRANSACTIONS_S.nextval FROM dual;
2966:
2967: --- Subfunction transact_serial
2968: Procedure transact_serial(
2969: -- p_new_transaction_temp_id IN NUMBER,