APPS.CSP_MO_MTLTXNS_UTIL dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

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 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 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