APPS.INV_LOT_API_PKG dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 649: SELECT * FROM mtl_transaction_lots_temp

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
650: WHERE ROWID = c_mtlt_hdr_id;
651:
652: l_mti_txn_id NUMBER;
653: l_mmtt_txn_id NUMBER;

Line 659: l_mtlt_txn_rec MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;

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:
663: l_get_dft_attr_rec c_get_dft_attr%ROWTYPE;