APPS.GME_INCREMENTAL_BACKFLUSH_PVT dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 823: FROM mtl_material_transactions m, mtl_transaction_lot_numbers l

819: ,v_batch_id IN NUMBER
820: ,v_mat_det_id IN NUMBER)
821: IS
822: SELECT lot_number, SUM (l.transaction_quantity) sum_trx
823: FROM mtl_material_transactions m, mtl_transaction_lot_numbers l
824: WHERE l.transaction_id = m.transaction_id
825: AND m.inventory_item_id = v_item_id
826: AND m.organization_id = v_organization_id
827: AND m.transaction_source_id = v_batch_id

Line 832: TYPE lot_qty_tab IS TABLE OF NUMBER INDEX BY mtl_transaction_lot_numbers.lot_number%TYPE;

828: AND m.trx_source_line_id = v_mat_det_id
829: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type
830: GROUP BY l.lot_number;
831:
832: TYPE lot_qty_tab IS TABLE OF NUMBER INDEX BY mtl_transaction_lot_numbers.lot_number%TYPE;
833:
834: l_lot_qty_tab lot_qty_tab;
835: l_last_lot_qty_tab lot_qty_tab;
836:

Line 861: ln mtl_transaction_lot_numbers.lot_number%TYPE;

857:
858: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
859: l_mmln_tbl_orig gme_common_pvt.mtl_trans_lots_num_tbl;
860: l_mmln_tbl_new gme_common_pvt.mtl_trans_lots_num_tbl;
861: ln mtl_transaction_lot_numbers.lot_number%TYPE;
862: l_lot_number mtl_transaction_lot_numbers.lot_number%TYPE;
863: /* Jalaj Srivastava Bug 5021522*/
864: l_item_no varchar2(2000);
865: inv_negative EXCEPTION;

Line 862: l_lot_number mtl_transaction_lot_numbers.lot_number%TYPE;

858: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
859: l_mmln_tbl_orig gme_common_pvt.mtl_trans_lots_num_tbl;
860: l_mmln_tbl_new gme_common_pvt.mtl_trans_lots_num_tbl;
861: ln mtl_transaction_lot_numbers.lot_number%TYPE;
862: l_lot_number mtl_transaction_lot_numbers.lot_number%TYPE;
863: /* Jalaj Srivastava Bug 5021522*/
864: l_item_no varchar2(2000);
865: inv_negative EXCEPTION;
866: