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_CLEAR1 dependencies on AR_CASH_RECEIPTS_ALL

Line 191: ar_cash_receipts_all cr

187: SELECT crh.status
188: INTO x_status
189: FROM ce_statement_recon_gt_v rec, --ce_statement_reconcils_all rec,
190: ar_cash_receipt_history_all crh,
191: ar_cash_receipts_all cr
192: WHERE rec.current_record_flag = 'Y' AND
193: rec.status_flag = 'M' AND
194: rec.reference_type = 'RECEIPT' AND
195: rec.reference_id = crh.cash_receipt_history_id AND

Line 529: receipt_id AR_CASH_RECEIPTS_ALL.cash_receipt_id%TYPE;

525: X_statement_amount NUMBER,
526: X_original_amount NUMBER,
527: X_effective_date DATE,
528: X_float_handling_flag VARCHAR2) IS
529: receipt_id AR_CASH_RECEIPTS_ALL.cash_receipt_id%TYPE;
530: receipt_history_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%TYPE;
531: receipt_type AR_CASH_RECEIPTS_ALL.type%TYPE;
532: receipt_status CE_LOOKUPS.lookup_code%TYPE;
533: receipt_date DATE;

Line 531: receipt_type AR_CASH_RECEIPTS_ALL.type%TYPE;

527: X_effective_date DATE,
528: X_float_handling_flag VARCHAR2) IS
529: receipt_id AR_CASH_RECEIPTS_ALL.cash_receipt_id%TYPE;
530: receipt_history_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%TYPE;
531: receipt_type AR_CASH_RECEIPTS_ALL.type%TYPE;
532: receipt_status CE_LOOKUPS.lookup_code%TYPE;
533: receipt_date DATE;
534: receipt_gl_date DATE;
535: amount_to_clear NUMBER;

Line 539: trx_exchange_rate_type AR_CASH_RECEIPTS_ALL.exchange_rate_type%TYPE;

535: amount_to_clear NUMBER;
536: trx_amount NUMBER;
537: adjusted_xrate_amount NUMBER;
538: trx_exchange_rate_date DATE;
539: trx_exchange_rate_type AR_CASH_RECEIPTS_ALL.exchange_rate_type%TYPE;
540: misc_receipt_id AR_CASH_RECEIPTS_ALL.cash_receipt_id%TYPE;
541: auto_reconcile_flag VARCHAR2(1);
542: l_amount NUMBER;
543: l_vat_tax_id NUMBER := to_number(null);

Line 540: misc_receipt_id AR_CASH_RECEIPTS_ALL.cash_receipt_id%TYPE;

536: trx_amount NUMBER;
537: adjusted_xrate_amount NUMBER;
538: trx_exchange_rate_date DATE;
539: trx_exchange_rate_type AR_CASH_RECEIPTS_ALL.exchange_rate_type%TYPE;
540: misc_receipt_id AR_CASH_RECEIPTS_ALL.cash_receipt_id%TYPE;
541: auto_reconcile_flag VARCHAR2(1);
542: l_amount NUMBER;
543: l_vat_tax_id NUMBER := to_number(null);
544: l_tax_rate NUMBER := to_number(null);