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 228: select xtr.settlement_summary_id

224: --
225: -- XTR transactions
226: --
227: CURSOR lock_185 (x_call_mode VARCHAR2, trx_rowid VARCHAR2) IS
228: select xtr.settlement_summary_id
229: FROM xtr_settlement_summary xtr,
230: ce_statement_reconcils_all rec
231: WHERE xtr.rowid = trx_rowid
232: AND rec.reference_id(+) = xtr.settlement_summary_id

Line 229: FROM xtr_settlement_summary xtr,

225: -- XTR transactions
226: --
227: CURSOR lock_185 (x_call_mode VARCHAR2, trx_rowid VARCHAR2) IS
228: select xtr.settlement_summary_id
229: FROM xtr_settlement_summary xtr,
230: ce_statement_reconcils_all rec
231: WHERE xtr.rowid = trx_rowid
232: AND rec.reference_id(+) = xtr.settlement_summary_id
233: AND rec.reference_type(+) = 'XTR_LINE'

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

228: select xtr.settlement_summary_id
229: FROM xtr_settlement_summary xtr,
230: ce_statement_reconcils_all rec
231: WHERE xtr.rowid = trx_rowid
232: AND rec.reference_id(+) = xtr.settlement_summary_id
233: AND rec.reference_type(+) = 'XTR_LINE'
234: AND NVL(rec.status_flag,X_call_mode) = x_call_mode
235: AND NVL(rec.current_record_flag,'Y') = 'Y'
236: FOR UPDATE OF xtr.settlement_summary_id NOWAIT;

Line 236: FOR UPDATE OF xtr.settlement_summary_id NOWAIT;

232: AND rec.reference_id(+) = xtr.settlement_summary_id
233: AND rec.reference_type(+) = 'XTR_LINE'
234: AND NVL(rec.status_flag,X_call_mode) = x_call_mode
235: AND NVL(rec.current_record_flag,'Y') = 'Y'
236: FOR UPDATE OF xtr.settlement_summary_id NOWAIT;
237:
238:
239: --
240: -- Receipts clearing