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.CE_AUTO_BANK_MATCH dependencies on XTR_SETTLEMENT_SUMMARY

Line 209: select xtr.settlement_summary_id

205: --
206: -- XTR transactions
207: --
208: CURSOR lock_185 (x_call_mode VARCHAR2, trx_rowid VARCHAR2) IS
209: select xtr.settlement_summary_id
210: FROM xtr_settlement_summary xtr,
211: ce_statement_reconcils_all rec
212: WHERE xtr.rowid = trx_rowid
213: AND rec.reference_id(+) = xtr.settlement_summary_id

Line 210: FROM xtr_settlement_summary xtr,

206: -- XTR transactions
207: --
208: CURSOR lock_185 (x_call_mode VARCHAR2, trx_rowid VARCHAR2) IS
209: select xtr.settlement_summary_id
210: FROM xtr_settlement_summary xtr,
211: ce_statement_reconcils_all rec
212: WHERE xtr.rowid = trx_rowid
213: AND rec.reference_id(+) = xtr.settlement_summary_id
214: AND rec.reference_type(+) = 'XTR_LINE'

Line 213: AND rec.reference_id(+) = xtr.settlement_summary_id

209: select xtr.settlement_summary_id
210: FROM xtr_settlement_summary xtr,
211: ce_statement_reconcils_all rec
212: WHERE xtr.rowid = trx_rowid
213: AND rec.reference_id(+) = xtr.settlement_summary_id
214: AND rec.reference_type(+) = 'XTR_LINE'
215: AND NVL(rec.status_flag,X_call_mode) = x_call_mode
216: AND NVL(rec.current_record_flag,'Y') = 'Y'
217: FOR UPDATE OF xtr.settlement_summary_id NOWAIT;

Line 217: FOR UPDATE OF xtr.settlement_summary_id NOWAIT;

213: AND rec.reference_id(+) = xtr.settlement_summary_id
214: AND rec.reference_type(+) = 'XTR_LINE'
215: AND NVL(rec.status_flag,X_call_mode) = x_call_mode
216: AND NVL(rec.current_record_flag,'Y') = 'Y'
217: FOR UPDATE OF xtr.settlement_summary_id NOWAIT;
218:
219:
220: --
221: -- Receipts clearing