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.ARP_DEDUCTION_COVER dependencies on AR_CASH_RECEIPTS

Line 309: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

305: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
306: l_attribute_rec AR_Receipt_API_PUB.attribute_rec_type;
307: l_global_attribute_rec AR_Receipt_API_PUB.global_attribute_rec_type;
308: l_balance NUMBER := 0;
309: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
310: l_receipt_date DATE;
311: l_currency_code ar_cash_receipts.currency_code%TYPE;
312: l_trx_currency_code ar_payment_schedules.invoice_currency_code%TYPE;
313: l_cr_gl_date DATE;

Line 311: l_currency_code ar_cash_receipts.currency_code%TYPE;

307: l_global_attribute_rec AR_Receipt_API_PUB.global_attribute_rec_type;
308: l_balance NUMBER := 0;
309: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
310: l_receipt_date DATE;
311: l_currency_code ar_cash_receipts.currency_code%TYPE;
312: l_trx_currency_code ar_payment_schedules.invoice_currency_code%TYPE;
313: l_cr_gl_date DATE;
314: l_cr_payment_schedule_id NUMBER;
315: l_customer_id NUMBER;

Line 736: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

732: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
733: l_attribute_rec AR_Receipt_API_PUB.attribute_rec_type;
734: l_global_attribute_rec AR_Receipt_API_PUB.global_attribute_rec_type;
735: l_balance NUMBER := 0;
736: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
737: l_receipt_date DATE;
738: l_currency_code ar_cash_receipts.currency_code%TYPE;
739: l_trx_currency_code ar_payment_schedules.invoice_currency_code%TYPE;
740: l_installment ar_payment_schedules.terms_sequence_number%TYPE;

Line 738: l_currency_code ar_cash_receipts.currency_code%TYPE;

734: l_global_attribute_rec AR_Receipt_API_PUB.global_attribute_rec_type;
735: l_balance NUMBER := 0;
736: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
737: l_receipt_date DATE;
738: l_currency_code ar_cash_receipts.currency_code%TYPE;
739: l_trx_currency_code ar_payment_schedules.invoice_currency_code%TYPE;
740: l_installment ar_payment_schedules.terms_sequence_number%TYPE;
741: l_cr_gl_date DATE;
742: l_cr_payment_schedule_id NUMBER;

Line 1217: FROM ar_cash_receipts cr

1213: , x_cr_gl_date
1214: , x_customer_id
1215: , x_currency_code
1216: , x_cr_payment_schedule_id
1217: FROM ar_cash_receipts cr
1218: , ar_payment_schedules ps
1219: , ar_cash_receipt_history crh
1220: WHERE cr.cash_receipt_id = crh.cash_receipt_id(+)
1221: AND crh.first_posted_record_flag(+) = 'Y'