DBA Data[Home] [Help]

APPS.GME_CLOSE_BATCH_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 528: FROM mtl_material_transactions mmt

524: CURSOR cur_inventory_txns (v_mat_det_id NUMBER, v_batch_id NUMBER,
525: v_txn_source_type NUMBER, v_pairs_reversal_type NUMBER)
526: IS
527: SELECT transaction_date
528: FROM mtl_material_transactions mmt
529: WHERE trx_source_line_id = v_mat_det_id
530: AND transaction_source_id = v_batch_id
531: AND transaction_source_type_id = v_txn_source_type
532: AND NOT EXISTS ( SELECT /*+ no_unnest */