APPS.INV_LOT_API_PKG dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 600: SELECT * FROM mtl_transaction_lots_interface

596: SELECT * FROM mtl_transactions_interface
597: WHERE transaction_interface_id = c_mti_hdr_id;
598:
599: CURSOR cur_get_mtli_rec (c_mtli_hdr_id ROWID) IS
600: SELECT * FROM mtl_transaction_lots_interface
601: WHERE ROWID = c_mtli_hdr_id;
602:
603: CURSOR cur_get_mmtt_rec (c_mmtt_hdr_id NUMBER) IS
604: SELECT * FROM mtl_material_transactions_temp

Line 616: l_mtli_txn_rec MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE;

612: l_mmtt_txn_id NUMBER;
613: l_mtli_txn_id ROWID;
614: l_mtlt_txn_id ROWID;
615: l_mti_txn_rec MTL_TRANSACTIONS_INTERFACE%ROWTYPE;
616: l_mtli_txn_rec MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE;
617: l_mmtt_txn_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;
618: l_mtlt_txn_rec MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;
619: l_lot_expiration_date DATE;
620: -- nsinghi bug 5209065 END