APPS.GME_INCREMENTAL_BACKFLUSH_PVT dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 1001: FROM mtl_material_transactions m, mtl_transaction_lot_numbers l

997: ,v_batch_id IN NUMBER
998: ,v_mat_det_id IN NUMBER)
999: IS
1000: SELECT lot_number, SUM (l.transaction_quantity) sum_trx
1001: FROM mtl_material_transactions m, mtl_transaction_lot_numbers l
1002: WHERE l.transaction_id = m.transaction_id
1003: AND m.inventory_item_id = v_item_id
1004: AND m.organization_id = v_organization_id
1005: AND m.transaction_source_id = v_batch_id

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

1006: AND m.trx_source_line_id = v_mat_det_id
1007: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type
1008: GROUP BY l.lot_number;
1009:
1010: TYPE lot_qty_tab IS TABLE OF NUMBER INDEX BY mtl_transaction_lot_numbers.lot_number%TYPE;
1011:
1012: l_lot_qty_tab lot_qty_tab;
1013: l_last_lot_qty_tab lot_qty_tab;
1014:

Line 1045: ln mtl_transaction_lot_numbers.lot_number%TYPE;

1041: l_mmln_tbl_new gme_common_pvt.mtl_trans_lots_num_tbl;
1042:
1043: -- Bug 9072371 add this table to allow checking for one lot.
1044: l_mmln_tbl_lot gme_common_pvt.mtl_trans_lots_num_tbl;
1045: ln mtl_transaction_lot_numbers.lot_number%TYPE;
1046: l_lot_number mtl_transaction_lot_numbers.lot_number%TYPE;
1047: /* Jalaj Srivastava Bug 5021522*/
1048: l_item_no varchar2(2000);
1049: inv_negative EXCEPTION;

Line 1046: l_lot_number mtl_transaction_lot_numbers.lot_number%TYPE;

1042:
1043: -- Bug 9072371 add this table to allow checking for one lot.
1044: l_mmln_tbl_lot gme_common_pvt.mtl_trans_lots_num_tbl;
1045: ln mtl_transaction_lot_numbers.lot_number%TYPE;
1046: l_lot_number mtl_transaction_lot_numbers.lot_number%TYPE;
1047: /* Jalaj Srivastava Bug 5021522*/
1048: l_item_no varchar2(2000);
1049: inv_negative EXCEPTION;
1050: