APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 906: FROM MTL_MATERIAL_TRANSACTIONS_TEMP M

902: /*
903: If p_shipment_number is not null then
904: Begin
905: SELECT SHIPMENT_NUMBER INTO l_ship_number
906: FROM MTL_MATERIAL_TRANSACTIONS_TEMP M
907: WHERE M.SHIPMENT_NUMBER = p_shipment_number AND ROWNUM = 1;
908: Exception
909: When no_data_found then
910: l_ship_number := Null;

Line 1293: -- Purpose : This procedure copies the data from the given mtl_material_transactions_temp record to the

1289: PROCEDURE transact_temp_record(
1290: /*$Header: csppttnb.pls 120.6 2008/02/18 06:27:08 htank ship $*/
1291: -- Start of Comments
1292: -- Procedure name : transact_temp_record
1293: -- Purpose : This procedure copies the data from the given mtl_material_transactions_temp record to the
1294: -- mtl_transactions_temp_interface table. It will also analyzed whether the item associated with the
1295: -- the given temp id is under serial or lot control. If the item is under under lot or serial control, this
1296: -- procedure inserts the necessary data into the mtl_lot_transactions_interface table or the
1297: -- mtl_serial_numbers_interface table. After the insertion completes, it deletes the existing record from

Line 1298: -- the mtl_material_transactions_temp, mtl_transaction_lots_temp or the mtl_serial_numbers_temp tables.

1294: -- mtl_transactions_temp_interface table. It will also analyzed whether the item associated with the
1295: -- the given temp id is under serial or lot control. If the item is under under lot or serial control, this
1296: -- procedure inserts the necessary data into the mtl_lot_transactions_interface table or the
1297: -- mtl_serial_numbers_interface table. After the insertion completes, it deletes the existing record from
1298: -- the mtl_material_transactions_temp, mtl_transaction_lots_temp or the mtl_serial_numbers_temp tables.
1299: --
1300: -- History :
1301: -- Person Date Descriptions
1302: -- ------ ---- --------------

Line 1353: from mtl_material_transactions_temp

1349: transfer_to_location ,
1350: transfer_organization ,
1351: trx_source_line_id ,
1352: expected_arrival_date
1353: from mtl_material_transactions_temp
1354: where transaction_temp_id = p_transaction_temp_id;
1355:
1356: Cursor l_Get_Lot_Temp_Csr IS
1357: select transaction_temp_id, serial_transaction_temp_id,

Line 1459: from mtl_material_transactions_temp

1455: RAISE EXCP_USER_DEFINED;
1456: ELSE
1457: BEGIN
1458: select transaction_temp_id into l_check_existence
1459: from mtl_material_transactions_temp
1460: where transaction_temp_id = p_transaction_temp_id;
1461: EXCEPTION
1462: WHEN NO_DATA_FOUND THEN
1463: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');