eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_SERIAL_NUMBERS_TEMP

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 1637: select transaction_temp_id, fm_serial_number, to_serial_number, serial_prefix from mtl_serial_numbers_temp

1633: from mtl_transaction_lots_temp
1634: where transaction_temp_id = p_transaction_temp_id;
1635:
1636: Cursor l_Get_Serial_Temp_Csr(l_transaction_temp_id NUMBER) IS
1637: select transaction_temp_id, fm_serial_number, to_serial_number, serial_prefix from mtl_serial_numbers_temp
1638: where transaction_temp_id = l_transaction_temp_id;
1639:
1640: Cursor l_Get_txn_header_id_csr IS
1641: SELECT mtl_material_transactions_s.nextval