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.INV_LOT_API_PKG dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 645: SELECT * FROM mtl_material_transactions_temp

641: SELECT * FROM mtl_transaction_lots_interface
642: WHERE ROWID = c_mtli_hdr_id;
643:
644: CURSOR cur_get_mmtt_rec (c_mmtt_hdr_id NUMBER) IS
645: SELECT * FROM mtl_material_transactions_temp
646: WHERE transaction_header_id = c_mmtt_hdr_id;
647:
648: CURSOR cur_get_mtlt_rec (c_mtlt_hdr_id ROWID) IS
649: SELECT * FROM mtl_transaction_lots_temp

Line 658: l_mmtt_txn_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;

654: l_mtli_txn_id ROWID;
655: l_mtlt_txn_id ROWID;
656: l_mti_txn_rec MTL_TRANSACTIONS_INTERFACE%ROWTYPE;
657: l_mtli_txn_rec MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE;
658: l_mmtt_txn_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;
659: l_mtlt_txn_rec MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;
660: l_lot_expiration_date DATE;
661: -- nsinghi bug 5209065 END
662: