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.PON_EMD_AR_INTEGRATION_GRP dependencies on AR_CASH_RECEIPT_HISTORY

Line 463: l_gl_date ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL;

459: l_amount ar_cash_receipts.amount%TYPE DEFAULT NULL;
460: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL;
461: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;
462: l_receipt_date ar_cash_receipts.receipt_date%TYPE DEFAULT NULL;
463: l_gl_date ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL;
464: l_maturity_date DATE DEFAULT NULL;
465: l_postmark_date DATE DEFAULT NULL;
466: l_customer_id ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL;
467: l_customer_name hz_parties.party_name%TYPE DEFAULT NULL;

Line 4363: FROM ar_cash_Receipt_history_all acrh,

4359: SELECT acr.receipt_number,
4360: acrh.status
4361: INTO x_receipt_num,
4362: x_receipt_status
4363: FROM ar_cash_Receipt_history_all acrh,
4364: ar_cash_receipts_all acr
4365: WHERE acrh.cash_receipt_id =acr.cash_receipt_id
4366: AND acrh.current_record_flag = 'Y'
4367: AND acrh.status = 'CLEARED'