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 173: ce_statement_reconcils_all rec

169: --
170: CURSOR lock_101 (x_call_mode VARCHAR2, trx_rowid VARCHAR2) IS
171: SELECT jel.je_header_id
172: FROM gl_je_lines jel,
173: ce_statement_reconcils_all rec
174: WHERE jel.rowid = trx_rowid
175: AND rec.reference_id(+) = jel.je_line_num
176: AND rec.je_header_id(+) = jel.je_header_id
177: AND rec.reference_type(+) = 'JE_LINE'

Line 188: ce_statement_reconcils_all rec

184: --
185: CURSOR lock_200 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
186: SELECT c.check_id
187: FROM ap_checks_all c,
188: ce_statement_reconcils_all rec
189: WHERE c.rowid = trx_rowid
190: AND rec.reference_id(+) = c.check_id
191: AND rec.reference_type(+) = 'PAYMENT'
192: AND NVL(rec.status_flag,x_call_mode) = X_call_mode

Line 214: ce_statement_reconcils_all rec

210: cr.cash_receipt_id,
211: NVL(crh.current_record_flag,'N')
212: FROM ar_cash_receipts_all cr,
213: ar_cash_receipt_history_all crh,
214: ce_statement_reconcils_all rec
215: WHERE cr.cash_receipt_id = crh.cash_receipt_id
216: AND crh.rowid = trx_rowid
217: AND rec.reference_id(+) = crh.cash_receipt_history_id
218: AND rec.reference_type(+) = decode(arp_cashbook.receipt_debit_memo_reversed(crh.cash_receipt_id), 'Y', 'DM REVERSAL', 'RECEIPT')

Line 230: ce_statement_reconcils_all rec

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

Line 259: ce_statement_reconcils_all rec

255: --
256: CURSOR lock_260 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
257: SELECT cl.statement_line_id
258: FROM ce_statement_lines cl,
259: ce_statement_reconcils_all rec
260: WHERE cl.rowid = trx_rowid
261: AND rec.reference_id(+) = cl.statement_line_id
262: AND rec.reference_type(+) = 'STATEMENT'
263: AND NVL(rec.status_flag,x_call_mode) = X_call_mode

Line 282: ce_statement_reconcils_all rec

278: --
279: CURSOR lock_260_cf (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
280: SELECT cc.cashflow_id
281: FROM ce_cashflows cc,
282: ce_statement_reconcils_all rec
283: WHERE cc.rowid = trx_rowid
284: AND rec.reference_id(+) = cc.cashflow_id
285: AND rec.reference_type(+) = 'CASHFLOW'
286: AND NVL(rec.status_flag,x_call_mode) = X_call_mode

Line 305: ce_statement_reconcils_all rec

301: --
302: CURSOR lock_801 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
303: SELECT paa.assignment_action_id
304: FROM pay_assignment_actions paa,
305: ce_statement_reconcils_all rec
306: WHERE paa.rowid = trx_rowid
307: AND rec.reference_id(+) = paa.assignment_action_id
308: AND rec.reference_type(+) = 'PAY'
309: AND NVL(rec.status_flag,x_call_mode) = X_call_mode

Line 2194: ce_statement_reconcils_all rec,

2190: CE_AUTO_BANK_MATCH.trx_org_id,
2191: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2192: FROM gl_sets_of_books sob,
2193: ce_system_parameters sp,
2194: ce_statement_reconcils_all rec,
2195: ce_bank_acct_uses_ou_v aba,
2196: ce_bank_accounts ba,
2197: ce_bank_acct_uses_ou_v aba2,
2198: ce_bank_accounts ba2,

Line 2298: ce_statement_reconcils_all rec,

2294: CE_AUTO_BANK_MATCH.trx_org_id,
2295: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2296: FROM gl_sets_of_books sob,
2297: ce_system_parameters sp,
2298: ce_statement_reconcils_all rec,
2299: ce_bank_acct_uses_ou_v aba,
2300: ce_bank_accounts ba,
2301: ce_bank_acct_uses_ou_v aba2,
2302: ce_bank_accounts ba2,

Line 2491: ce_statement_reconcils_all rec,

2487: CE_AUTO_BANK_MATCH.trx_org_id,
2488: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2489: FROM gl_sets_of_books sob,
2490: ce_system_parameters sp,
2491: ce_statement_reconcils_all rec,
2492: ce_bank_accounts ba,
2493: ce_bank_acct_uses_ou_v aba,
2494: ap_payment_history_all aph,
2495: ap_checks_all c,

Line 2586: ce_statement_reconcils_all rec,

2582: CE_AUTO_BANK_MATCH.trx_org_id,
2583: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2584: FROM gl_sets_of_books sob,
2585: ce_system_parameters sp,
2586: ce_statement_reconcils_all rec,
2587: ce_bank_accounts ba,
2588: ce_bank_acct_uses_ou_v aba,
2589: ar_cash_receipt_history_all crh,
2590: ar_cash_receipts_all cr,

Line 4896: from ce_statement_reconcils_all r

4892: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
4893: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)
4894: AND NOT EXISTS
4895: (select NULL
4896: from ce_statement_reconcils_all r
4897: where r.statement_line_id = catv.statement_line_id
4898: and r.current_record_flag = 'Y'
4899: and nvl(r.status_flag, 'U') <> 'U'
4900: AND r.reference_type = 'STATEMENT');

Line 4943: from ce_statement_reconcils_all r

4939: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
4940: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)
4941: AND NOT EXISTS
4942: (select NULL
4943: from ce_statement_reconcils_all r
4944: where r.statement_line_id = catv.statement_line_id
4945: and r.current_record_flag = 'Y'
4946: and nvl(r.status_flag, 'U') <> 'U'
4947: AND r.reference_type = 'STATEMENT');

Line 5041: from ce_statement_reconcils_all r

5037: CE_AUTO_BANK_MATCH.csl_amount)) *
5038: CE_AUTO_BANK_MATCH.ba_ar_percent_tolerance / 100))
5039: AND NOT EXISTS
5040: (select NULL
5041: from ce_statement_reconcils_all r
5042: where r.statement_line_id = catv.statement_line_id
5043: and r.current_record_flag = 'Y'
5044: and nvl(r.status_flag, 'U') <> 'U'
5045: AND r.reference_type = 'STATEMENT');

Line 5139: from ce_statement_reconcils_all r

5135: CE_AUTO_BANK_MATCH.csl_amount)) *
5136: CE_AUTO_BANK_MATCH.ba_ar_percent_tolerance / 100))
5137: AND NOT EXISTS
5138: (select NULL
5139: from ce_statement_reconcils_all r
5140: where r.statement_line_id = catv.statement_line_id
5141: and r.current_record_flag = 'Y'
5142: and nvl(r.status_flag, 'U') <> 'U'
5143: AND r.reference_type = 'STATEMENT');

Line 5236: from ce_statement_reconcils_all r

5232: - CE_AUTO_BANK_MATCH.csl_amount)) *
5233: CE_AUTO_BANK_MATCH.ba_ap_percent_tolerance / 100))
5234: AND NOT EXISTS
5235: (select NULL
5236: from ce_statement_reconcils_all r
5237: where r.statement_line_id = catv.statement_line_id
5238: and r.current_record_flag = 'Y'
5239: and nvl(r.status_flag, 'U') <> 'U'
5240: AND r.reference_type = 'STATEMENT');

Line 5289: ce_statement_reconcils_all r, ce_statement_lines l

5285: v.seq_id
5286: --FROM ce_222_transactions_v v, gl_daily_conversion_types glcc,
5287: FROM ce_available_transactions_tmp v, gl_daily_conversion_types glcc,
5288: ar_cash_receipt_history_all ar, ce_statement_headers h,
5289: ce_statement_reconcils_all r, ce_statement_lines l
5290: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5291: AND nvl(l.bank_trx_number,'-9999') =
5292: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5293: AND (nvl(l.invoice_text, '-99999') =

Line 5404: ce_statement_reconcils_all r, ce_statement_lines l

5400: v2.seq_id
5401: --FROM ce_200_transactions_v v2, gl_daily_conversion_types glcc,
5402: FROM ce_available_transactions_tmp v2, gl_daily_conversion_types glcc,
5403: ce_statement_headers h,
5404: ce_statement_reconcils_all r, ce_statement_lines l
5405: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5406: AND nvl(l.bank_trx_number,'-9999') =
5407: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5408: AND (nvl(l.invoice_text, '-99999') =

Line 5792: delete from ce_statement_reconcils_all

5788: p_crh_id => CE_AUTO_BANK_MATCH.trx_id);
5789: end if;
5790:
5791: --delete from ce_statement_reconciliations
5792: delete from ce_statement_reconcils_all
5793: where statement_line_id = CE_AUTO_BANK_MATCH.trx_id2
5794: and request_id = nvl(FND_GLOBAL.conc_request_id,-1);
5795: CE_AUTO_BANK_MATCH.trx_id := CE_AUTO_BANK_MATCH.trx_id2;
5796: CE_AUTO_BANK_MATCH.csl_match_correction_type := 'REVERSAL';

Line 7559: CE_STATEMENT_RECONCILS_ALL CRE2,

7555: AND JEL.GL_SL_LINK_TABLE = XLL.GL_SL_LINK_TABLE
7556: AND NOT EXISTS
7557: (SELECT NULL
7558: FROM
7559: CE_STATEMENT_RECONCILS_ALL CRE2,
7560: CE_SYSTEM_PARAMETERS SYS2
7561: WHERE JEL.JE_HEADER_ID = CRE2.JE_HEADER_ID
7562: AND JEL.JE_LINE_NUM = CRE2.REFERENCE_ID
7563: AND CRE2.STATUS_FLAG = 'M'

Line 10122: from ce_statement_reconcils_all

10118:
10119: select count(*)
10120: into rec_status
10121: --from ce_statement_reconciliations
10122: from ce_statement_reconcils_all
10123: where statement_line_id =
10124: CE_AUTO_BANK_MATCH.csl_statement_line_id
10125: and nvl(status_flag, 'U') = 'M'
10126: and nvl(current_record_flag, 'Y') = 'Y';