DBA Data[Home] [Help]

APPS.GME_INCREMENTAL_BACKFLUSH_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

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 1036: l_mmt_rec mtl_material_transactions%ROWTYPE;

1032:
1033: -- Bug 13017256
1034: l_trans_date DATE;
1035:
1036: l_mmt_rec mtl_material_transactions%ROWTYPE;
1037: l_mmt_tbl gme_common_pvt.mtl_mat_tran_tbl;
1038:
1039: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
1040: l_mmln_tbl_orig gme_common_pvt.mtl_trans_lots_num_tbl;