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 362: FROM ar_cash_receipts_all t

358: BEGIN
359: IF p_cash_receipt_id IS NOT NULL THEN
360: SELECT t.org_id
361: INTO l_org_id
362: FROM ar_cash_receipts_all t
363: WHERE t.cash_receipt_id = p_cash_receipt_id;
364:
365: ar_mo_cache_utils.set_org_context_in_api(l_org_id, x_return_status);
366: END IF;

Line 753: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

749: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
750: l_attribute_rec AR_Receipt_API_PUB.attribute_rec_type;
751: l_global_attribute_rec AR_Receipt_API_PUB.global_attribute_rec_type;
752: l_balance NUMBER := 0;
753: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
754: l_receipt_date DATE;
755: l_currency_code ar_cash_receipts.currency_code%TYPE;
756: l_trx_currency_code ar_payment_schedules.invoice_currency_code%TYPE;
757: l_installment ar_payment_schedules.terms_sequence_number%TYPE;

Line 755: l_currency_code ar_cash_receipts.currency_code%TYPE;

751: l_global_attribute_rec AR_Receipt_API_PUB.global_attribute_rec_type;
752: l_balance NUMBER := 0;
753: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
754: l_receipt_date DATE;
755: l_currency_code ar_cash_receipts.currency_code%TYPE;
756: l_trx_currency_code ar_payment_schedules.invoice_currency_code%TYPE;
757: l_installment ar_payment_schedules.terms_sequence_number%TYPE;
758: l_cr_gl_date DATE;
759: l_cr_payment_schedule_id NUMBER;

Line 835: FROM ar_cash_receipts_all t

831: BEGIN
832: IF p_cash_receipt_id IS NOT NULL THEN
833: SELECT t.org_id
834: INTO l_org_id
835: FROM ar_cash_receipts_all t
836: WHERE t.cash_receipt_id = p_cash_receipt_id;
837:
838: ar_mo_cache_utils.set_org_context_in_api(l_org_id, x_return_status);
839: END IF;

Line 1251: FROM ar_cash_receipts cr

1247: , x_cr_gl_date
1248: , x_customer_id
1249: , x_currency_code
1250: , x_cr_payment_schedule_id
1251: FROM ar_cash_receipts cr
1252: , ar_payment_schedules ps
1253: , ar_cash_receipt_history crh
1254: WHERE cr.cash_receipt_id = crh.cash_receipt_id(+)
1255: AND crh.first_posted_record_flag(+) = 'Y'