APPS.GME_CLOSE_BATCH_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 233: FROM mtl_material_transactions_temp mmtt

229: AND NOT EXISTS (SELECT 1
230: FROM mtl_txn_request_headers mtrh
231: WHERE mtrh.header_id = l.header_id)
232: AND NOT EXISTS (SELECT 1
233: FROM mtl_material_transactions_temp mmtt
234: where l.line_id = mmtt.move_order_line_id);
235: END LOOP;
236: -- End Bug 10100973
237:

Line 632: FROM mtl_material_transactions mmt

628: CURSOR cur_inventory_txns (v_mat_det_id NUMBER, v_batch_id NUMBER,
629: v_txn_source_type NUMBER, v_pairs_reversal_type NUMBER)
630: IS
631: SELECT transaction_date
632: FROM mtl_material_transactions mmt
633: WHERE trx_source_line_id = v_mat_det_id
634: AND transaction_source_id = v_batch_id
635: AND transaction_source_type_id = v_txn_source_type
636: AND NOT EXISTS ( SELECT /*+ no_unnest */