APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1031: FROM MTL_MATERIAL_TRANSACTIONS_TEMP M

1027: /*
1028: If p_shipment_number is not null then
1029: Begin
1030: SELECT SHIPMENT_NUMBER INTO l_ship_number
1031: FROM MTL_MATERIAL_TRANSACTIONS_TEMP M
1032: WHERE M.SHIPMENT_NUMBER = p_shipment_number AND ROWNUM = 1;
1033: Exception
1034: When no_data_found then
1035: l_ship_number := Null;

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

1563: PROCEDURE transact_temp_record(
1564: /*$Header: csppttnb.pls 120.30.12020000.4 2013/02/11 08:52:32 htank ship $*/
1565: -- Start of Comments
1566: -- Procedure name : transact_temp_record
1567: -- Purpose : This procedure copies the data from the given mtl_material_transactions_temp record to the
1568: -- mtl_transactions_temp_interface table. It will also analyzed whether the item associated with the
1569: -- the given temp id is under serial or lot control. If the item is under under lot or serial control, this
1570: -- procedure inserts the necessary data into the mtl_lot_transactions_interface table or the
1571: -- mtl_serial_numbers_interface table. After the insertion completes, it deletes the existing record from

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

1568: -- mtl_transactions_temp_interface table. It will also analyzed whether the item associated with the
1569: -- the given temp id is under serial or lot control. If the item is under under lot or serial control, this
1570: -- procedure inserts the necessary data into the mtl_lot_transactions_interface table or the
1571: -- mtl_serial_numbers_interface table. After the insertion completes, it deletes the existing record from
1572: -- the mtl_material_transactions_temp, mtl_transaction_lots_temp or the mtl_serial_numbers_temp tables.
1573: --
1574: -- History :
1575: -- Person Date Descriptions
1576: -- ------ ---- --------------

Line 1627: from mtl_material_transactions_temp

1623: transfer_to_location ,
1624: transfer_organization ,
1625: trx_source_line_id ,
1626: expected_arrival_date
1627: from mtl_material_transactions_temp
1628: where transaction_temp_id = p_transaction_temp_id;
1629:
1630: Cursor l_Get_Lot_Temp_Csr IS
1631: select transaction_temp_id, serial_transaction_temp_id,

Line 1733: from mtl_material_transactions_temp

1729: RAISE EXCP_USER_DEFINED;
1730: ELSE
1731: BEGIN
1732: select transaction_temp_id into l_check_existence
1733: from mtl_material_transactions_temp
1734: where transaction_temp_id = p_transaction_temp_id;
1735: EXCEPTION
1736: WHEN NO_DATA_FOUND THEN
1737: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');