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 AR_CASH_RECEIPT_HISTORY_ALL

Line 194: ar_cash_receipt_history_all crh,

190: SELECT crh.cash_receipt_history_id,
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

Line 228: ar_cash_receipt_history_all crh

224: SELECT crh.cash_receipt_history_id,
225: cr.cash_receipt_id,
226: NVL(crh.current_record_flag,'N')
227: FROM ar_cash_receipts_all cr,
228: ar_cash_receipt_history_all crh
229: WHERE cr.cash_receipt_id = crh.cash_receipt_id
230: AND crh.rowid = trx_rowid
231: FOR UPDATE OF crh.cash_receipt_history_id,
232: cr.cash_receipt_id NOWAIT;

Line 311: AR_CASH_RECEIPT_HISTORY_all CRH,

307: SELECT crh.cash_receipt_history_id,
308: cr.cash_receipt_id,
309: b.batch_id batch_id
310: FROM AR_CASH_RECEIPTS_all CR,
311: AR_CASH_RECEIPT_HISTORY_all CRH,
312: AR_CASH_RECEIPT_HISTORY_all CRH2,
313: AR_BATCHES_all B
314: WHERE b.rowid = trx_rowid
315: AND crh.cash_receipt_history_id = decode(crh.batch_id,

Line 312: AR_CASH_RECEIPT_HISTORY_all CRH2,

308: cr.cash_receipt_id,
309: b.batch_id batch_id
310: FROM AR_CASH_RECEIPTS_all CR,
311: AR_CASH_RECEIPT_HISTORY_all CRH,
312: AR_CASH_RECEIPT_HISTORY_all CRH2,
313: AR_BATCHES_all B
314: WHERE b.rowid = trx_rowid
315: AND crh.cash_receipt_history_id = decode(crh.batch_id,
316: null, crh2.reversal_cash_receipt_hist_id,

Line 1338: current_record_flag AR_CASH_RECEIPT_HISTORY_ALL.current_record_flag%TYPE;

1334: X_LOGICAL_GROUP_REFERENCE VARCHAR2 DEFAULT NULL) IS
1335: id1 NUMBER;
1336: id2 NUMBER;
1337: id3 NUMBER;
1338: current_record_flag AR_CASH_RECEIPT_HISTORY_ALL.current_record_flag%TYPE;
1339: tx_status CE_LOOKUPS.lookup_code%TYPE;
1340: batch_ba_amount NUMBER;
1341: BEGIN
1342: cep_standard.debug('>>CE_AUTO_BANK_MATCH.lock_transaction');

Line 2310: ar_cash_receipt_history_all crh,

2306: ce_bank_acct_uses_all aba,
2307: ce_bank_accounts ba,
2308: /* Bug 13610807: for customer account join with ext accts table */
2309: iby_ext_bank_accounts ext,
2310: ar_cash_receipt_history_all crh,
2311: ar_cash_receipts_all cr,
2312: ar_receivable_applications_all ra,
2313: ar_payment_schedules_all ps
2314: WHERE sob.set_of_books_id = sp.set_of_books_id

Line 2583: ar_cash_receipt_history_all crh,

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,
2585: ar_receivable_applications_all ra,
2586: --ra_customers rc,
2587: HZ_CUST_ACCOUNTS CU,

Line 5535: ar_cash_receipt_history_all ar, ce_statement_headers h,

5531: v.CE_BANK_ACCT_USE_ID,
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')

Line 5715: loc_trx_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%TYPE;

5711: calc_tolerance_amount NUMBER;
5712: calc_tolerance_amount_ap NUMBER;
5713: calc_tolerance_amount_ar NUMBER;
5714: loc_match_type CE_LOOKUPS.lookup_code%TYPE;
5715: loc_trx_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%TYPE;
5716: loc_cash_receipt_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_id%TYPE;
5717: loc_trx_date DATE;
5718:
5719: BEGIN

Line 5716: loc_cash_receipt_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_id%TYPE;

5712: calc_tolerance_amount_ap NUMBER;
5713: calc_tolerance_amount_ar NUMBER;
5714: loc_match_type CE_LOOKUPS.lookup_code%TYPE;
5715: loc_trx_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%TYPE;
5716: loc_cash_receipt_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_id%TYPE;
5717: loc_trx_date DATE;
5718:
5719: BEGIN
5720: cep_standard.debug('>>CE_AUTO_BANK_MATCH.stmtline_match');