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 213: ar_cash_receipt_history_all crh,

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

Line 247: ar_cash_receipt_history_all crh

243: SELECT crh.cash_receipt_history_id,
244: cr.cash_receipt_id,
245: NVL(crh.current_record_flag,'N')
246: FROM ar_cash_receipts_all cr,
247: ar_cash_receipt_history_all crh
248: WHERE cr.cash_receipt_id = crh.cash_receipt_id
249: AND crh.rowid = trx_rowid
250: FOR UPDATE OF crh.cash_receipt_history_id,
251: cr.cash_receipt_id NOWAIT;

Line 330: AR_CASH_RECEIPT_HISTORY_all CRH,

326: SELECT crh.cash_receipt_history_id,
327: cr.cash_receipt_id,
328: b.batch_id batch_id
329: FROM AR_CASH_RECEIPTS_all CR,
330: AR_CASH_RECEIPT_HISTORY_all CRH,
331: AR_CASH_RECEIPT_HISTORY_all CRH2,
332: AR_BATCHES_all B
333: WHERE b.rowid = trx_rowid
334: AND crh.cash_receipt_history_id = decode(crh.batch_id,

Line 331: AR_CASH_RECEIPT_HISTORY_all CRH2,

327: cr.cash_receipt_id,
328: b.batch_id batch_id
329: FROM AR_CASH_RECEIPTS_all CR,
330: AR_CASH_RECEIPT_HISTORY_all CRH,
331: AR_CASH_RECEIPT_HISTORY_all CRH2,
332: AR_BATCHES_all B
333: WHERE b.rowid = trx_rowid
334: AND crh.cash_receipt_history_id = decode(crh.batch_id,
335: null, crh2.reversal_cash_receipt_hist_id,

Line 1323: current_record_flag AR_CASH_RECEIPT_HISTORY_ALL.current_record_flag%TYPE;

1319: X_LOGICAL_GROUP_REFERENCE VARCHAR2 DEFAULT NULL) IS
1320: id1 NUMBER;
1321: id2 NUMBER;
1322: id3 NUMBER;
1323: current_record_flag AR_CASH_RECEIPT_HISTORY_ALL.current_record_flag%TYPE;
1324: tx_status CE_LOOKUPS.lookup_code%TYPE;
1325: batch_ba_amount NUMBER;
1326: BEGIN
1327: cep_standard.debug('>>CE_AUTO_BANK_MATCH.lock_transaction');

Line 2303: ar_cash_receipt_history_all crh,

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,
2303: ar_cash_receipt_history_all crh,
2304: ar_cash_receipts_all cr,
2305: ar_receivable_applications_all ra,
2306: ar_payment_schedules_all ps
2307: WHERE sob.set_of_books_id = sp.set_of_books_id

Line 2589: ar_cash_receipt_history_all crh,

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,
2591: ar_receivable_applications_all ra,
2592: --ra_customers rc,
2593: HZ_CUST_ACCOUNTS CU,

Line 5288: ar_cash_receipt_history_all ar, ce_statement_headers h,

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

Line 5468: loc_trx_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%TYPE;

5464: calc_tolerance_amount NUMBER;
5465: calc_tolerance_amount_ap NUMBER;
5466: calc_tolerance_amount_ar NUMBER;
5467: loc_match_type CE_LOOKUPS.lookup_code%TYPE;
5468: loc_trx_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%TYPE;
5469: loc_cash_receipt_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_id%TYPE;
5470: loc_trx_date DATE;
5471:
5472: BEGIN

Line 5469: loc_cash_receipt_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_id%TYPE;

5465: calc_tolerance_amount_ap NUMBER;
5466: calc_tolerance_amount_ar NUMBER;
5467: loc_match_type CE_LOOKUPS.lookup_code%TYPE;
5468: loc_trx_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%TYPE;
5469: loc_cash_receipt_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_id%TYPE;
5470: loc_trx_date DATE;
5471:
5472: BEGIN
5473: cep_standard.debug('>>CE_AUTO_BANK_MATCH.stmtline_match');