DBA Data[Home] [Help]

APPS.GME_INCREMENTAL_BACKFLUSH_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

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

851: i NUMBER;
852: j NUMBER;
853: k NUMBER;
854:
855: l_mmt_rec mtl_material_transactions%ROWTYPE;
856: l_mmt_tbl gme_common_pvt.mtl_mat_tran_tbl;
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;