APPS.MTL_LOT_UOM_CONV_PVT dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 393: From mtl_transaction_lot_numbers

389: AND pair_type = 1) --gme_common_pvt.g_pairs_reversal_type
390: AND inventory_item_id = p_lot_uom_conv_rec.inventory_item_id
391: AND organization_id = p_lot_uom_conv_rec.organization_id
392: AND EXISTS (select 1
393: From mtl_transaction_lot_numbers
394: Where transaction_id = mmt.transaction_id
395: And lot_number = p_lot_uom_conv_rec.lot_number);
396:
397:

Line 400: FROM mtl_transaction_lot_numbers

396:
397:
398: Cursor get_lot_transactions (v_transaction_id NUMBER) IS
399: SELECT *
400: FROM mtl_transaction_lot_numbers
401: WHERE transaction_id = v_transaction_id
402: AND lot_number = p_lot_uom_conv_rec.lot_number;
403:
404: x_batch_txns mtl_material_transactions%ROWTYPE;

Line 405: x_lot_txns mtl_transaction_lot_numbers%ROWTYPE;

401: WHERE transaction_id = v_transaction_id
402: AND lot_number = p_lot_uom_conv_rec.lot_number;
403:
404: x_batch_txns mtl_material_transactions%ROWTYPE;
405: x_lot_txns mtl_transaction_lot_numbers%ROWTYPE;
406: l_lot_transactions_tbl GME_COMMON_PVT.mtl_trans_lots_num_tbl;
407: i NUMBER;
408: j NUMBER;
409: txn_ind NUMBER;