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 CE_STATEMENT_RECONCILS_ALL

Line 154: ce_statement_reconcils_all rec

150: --
151: CURSOR lock_101 (x_call_mode VARCHAR2, trx_rowid VARCHAR2) IS
152: SELECT jel.je_header_id
153: FROM gl_je_lines jel,
154: ce_statement_reconcils_all rec
155: WHERE jel.rowid = trx_rowid
156: AND rec.reference_id(+) = jel.je_line_num
157: AND rec.je_header_id(+) = jel.je_header_id
158: AND rec.reference_type(+) = 'JE_LINE'

Line 169: ce_statement_reconcils_all rec

165: --
166: CURSOR lock_200 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
167: SELECT c.check_id
168: FROM ap_checks_all c,
169: ce_statement_reconcils_all rec
170: WHERE c.rowid = trx_rowid
171: AND rec.reference_id(+) = c.check_id
172: AND rec.reference_type(+) = 'PAYMENT'
173: AND NVL(rec.status_flag,x_call_mode) = X_call_mode

Line 195: ce_statement_reconcils_all rec

191: cr.cash_receipt_id,
192: NVL(crh.current_record_flag,'N')
193: FROM ar_cash_receipts_all cr,
194: ar_cash_receipt_history_all crh,
195: ce_statement_reconcils_all rec
196: WHERE cr.cash_receipt_id = crh.cash_receipt_id
197: AND crh.rowid = trx_rowid
198: AND rec.reference_id(+) = crh.cash_receipt_history_id
199: AND rec.reference_type(+) = decode(arp_cashbook.receipt_debit_memo_reversed(crh.cash_receipt_id), 'Y', 'DM REVERSAL', 'RECEIPT')

Line 211: ce_statement_reconcils_all rec

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'
215: AND NVL(rec.status_flag,X_call_mode) = x_call_mode

Line 240: ce_statement_reconcils_all rec

236: --
237: CURSOR lock_260 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
238: SELECT cl.statement_line_id
239: FROM ce_statement_lines cl,
240: ce_statement_reconcils_all rec
241: WHERE cl.rowid = trx_rowid
242: AND rec.reference_id(+) = cl.statement_line_id
243: AND rec.reference_type(+) = 'STATEMENT'
244: AND NVL(rec.status_flag,x_call_mode) = X_call_mode

Line 263: ce_statement_reconcils_all rec

259: --
260: CURSOR lock_260_cf (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
261: SELECT cc.cashflow_id
262: FROM ce_cashflows cc,
263: ce_statement_reconcils_all rec
264: WHERE cc.rowid = trx_rowid
265: AND rec.reference_id(+) = cc.cashflow_id
266: AND rec.reference_type(+) = 'CASHFLOW'
267: AND NVL(rec.status_flag,x_call_mode) = X_call_mode

Line 286: ce_statement_reconcils_all rec

282: --
283: CURSOR lock_801 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
284: SELECT paa.assignment_action_id
285: FROM pay_assignment_actions paa,
286: ce_statement_reconcils_all rec
287: WHERE paa.rowid = trx_rowid
288: AND rec.reference_id(+) = paa.assignment_action_id
289: AND rec.reference_type(+) = 'PAY'
290: AND NVL(rec.status_flag,x_call_mode) = X_call_mode

Line 2199: ce_statement_reconcils_all rec,

2195: CE_AUTO_BANK_MATCH.trx_org_id,
2196: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2197: FROM gl_sets_of_books sob,
2198: ce_system_parameters sp,
2199: ce_statement_reconcils_all rec,
2200: ce_bank_acct_uses_ou_v aba,
2201: ce_bank_accounts ba,
2202: --ce_bank_acct_uses_ou_v aba2, -- Bug 9062935 removed use of view
2203: iby_ext_bank_accounts ext, -- Bug 9062935

Line 2304: ce_statement_reconcils_all rec,

2300: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2301: FROM
2302: gl_sets_of_books sob,
2303: ce_system_parameters sp,
2304: ce_statement_reconcils_all rec,
2305: /* Bug 13610807: do not use ce_bank_acct_uses_ou_v aba*/
2306: ce_bank_acct_uses_all aba,
2307: ce_bank_accounts ba,
2308: /* Bug 13610807: for customer account join with ext accts table */

Line 2484: ce_statement_reconcils_all rec,

2480: CE_AUTO_BANK_MATCH.trx_org_id,
2481: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2482: FROM gl_sets_of_books sob,
2483: ce_system_parameters sp,
2484: ce_statement_reconcils_all rec,
2485: ce_bank_accounts ba,
2486: ce_bank_acct_uses_ou_v aba,
2487: ap_payment_history_all aph,
2488: ap_checks_all c,

Line 2580: ce_statement_reconcils_all rec,

2576: CE_AUTO_BANK_MATCH.trx_org_id,
2577: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2578: FROM gl_sets_of_books sob,
2579: ce_system_parameters sp,
2580: ce_statement_reconcils_all rec,
2581: ce_bank_accounts ba,
2582: ce_bank_acct_uses_ou_v aba,
2583: ar_cash_receipt_history_all crh,
2584: ar_cash_receipts_all cr,

Line 5143: from ce_statement_reconcils_all r

5139: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
5140: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)
5141: AND NOT EXISTS
5142: (select NULL
5143: from ce_statement_reconcils_all r
5144: where r.statement_line_id = catv.statement_line_id
5145: and r.current_record_flag = 'Y'
5146: and nvl(r.status_flag, 'U') <> 'U'
5147: AND r.reference_type = 'STATEMENT');

Line 5190: from ce_statement_reconcils_all r

5186: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
5187: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)
5188: AND NOT EXISTS
5189: (select NULL
5190: from ce_statement_reconcils_all r
5191: where r.statement_line_id = catv.statement_line_id
5192: and r.current_record_flag = 'Y'
5193: and nvl(r.status_flag, 'U') <> 'U'
5194: AND r.reference_type = 'STATEMENT');

Line 5288: from ce_statement_reconcils_all r

5284: CE_AUTO_BANK_MATCH.csl_amount)) *
5285: CE_AUTO_BANK_MATCH.ba_ar_percent_tolerance / 100))
5286: AND NOT EXISTS
5287: (select NULL
5288: from ce_statement_reconcils_all r
5289: where r.statement_line_id = catv.statement_line_id
5290: and r.current_record_flag = 'Y'
5291: and nvl(r.status_flag, 'U') <> 'U'
5292: AND r.reference_type = 'STATEMENT');

Line 5386: from ce_statement_reconcils_all r

5382: CE_AUTO_BANK_MATCH.csl_amount)) *
5383: CE_AUTO_BANK_MATCH.ba_ar_percent_tolerance / 100))
5384: AND NOT EXISTS
5385: (select NULL
5386: from ce_statement_reconcils_all r
5387: where r.statement_line_id = catv.statement_line_id
5388: and r.current_record_flag = 'Y'
5389: and nvl(r.status_flag, 'U') <> 'U'
5390: AND r.reference_type = 'STATEMENT');

Line 5483: from ce_statement_reconcils_all r

5479: - CE_AUTO_BANK_MATCH.csl_amount)) *
5480: CE_AUTO_BANK_MATCH.ba_ap_percent_tolerance / 100))
5481: AND NOT EXISTS
5482: (select NULL
5483: from ce_statement_reconcils_all r
5484: where r.statement_line_id = catv.statement_line_id
5485: and r.current_record_flag = 'Y'
5486: and nvl(r.status_flag, 'U') <> 'U'
5487: AND r.reference_type = 'STATEMENT');

Line 5536: ce_statement_reconcils_all r, ce_statement_lines l

5532: v.seq_id
5533: --FROM ce_222_transactions_v v, gl_daily_conversion_types glcc,
5534: FROM ce_available_transactions_tmp v, gl_daily_conversion_types glcc,
5535: ar_cash_receipt_history_all ar, ce_statement_headers h,
5536: ce_statement_reconcils_all r, ce_statement_lines l
5537: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5538: AND nvl(l.bank_trx_number,'-9999') =
5539: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5540: AND (nvl(l.invoice_text, '-99999') =

Line 5651: ce_statement_reconcils_all r, ce_statement_lines l

5647: v2.seq_id
5648: --FROM ce_200_transactions_v v2, gl_daily_conversion_types glcc,
5649: FROM ce_available_transactions_tmp v2, gl_daily_conversion_types glcc,
5650: ce_statement_headers h,
5651: ce_statement_reconcils_all r, ce_statement_lines l
5652: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5653: AND nvl(l.bank_trx_number,'-9999') =
5654: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5655: AND (nvl(l.invoice_text, '-99999') =

Line 6039: delete from ce_statement_reconcils_all

6035: p_crh_id => CE_AUTO_BANK_MATCH.trx_id);
6036: end if;
6037:
6038: --delete from ce_statement_reconciliations
6039: delete from ce_statement_reconcils_all
6040: where statement_line_id = CE_AUTO_BANK_MATCH.trx_id2
6041: and request_id = nvl(FND_GLOBAL.conc_request_id,-1);
6042: CE_AUTO_BANK_MATCH.trx_id := CE_AUTO_BANK_MATCH.trx_id2;
6043: CE_AUTO_BANK_MATCH.csl_match_correction_type := 'REVERSAL';

Line 10263: from ce_statement_reconcils_all

10259: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id := NULL; -- Bug 8945387
10260:
10261: select count(*)
10262: into rec_status
10263: from ce_statement_reconcils_all
10264: where statement_line_id = CE_AUTO_BANK_MATCH.csl_statement_line_id
10265: and nvl(status_flag, 'U') = 'M'
10266: and nvl(current_record_flag, 'Y') = 'Y';
10267: