eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_CE_BATCH_RECON_PKG dependencies on CE_PAYMENT_TRANSACTIONS

Line 139: from ce_payment_transactions pt

135: ('CE_STMT_RECORDED', 'CE_BAT_CLEARED', 'CE_BAT_CREATED')
136: and cc.source_trxn_type ='BAT'
137: AND exists
138: (select null
139: from ce_payment_transactions pt
140: where cc.trxn_reference_number = pt.trxn_reference_number
141: and pt.trxn_reference_number = cc.trxn_reference_number
142: and pt.trxn_status_code = 'SETTLED')
143: and cc.trxn_reference_number = docs.calling_app_doc_ref_number

Line 183: from ce_payment_transactions pt

179: ('CE_STMT_RECORDED', 'CE_BAT_CLEARED', 'CE_BAT_CREATED')
180: and cc.source_trxn_type ='BAT'
181: AND exists
182: (select null
183: from ce_payment_transactions pt
184: where cc.trxn_reference_number = pt.trxn_reference_number
185: and pt.trxn_reference_number = cc.trxn_reference_number
186: and pt.trxn_status_code = 'SETTLED')
187: and cc.trxn_reference_number = docs.calling_app_doc_ref_number