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

Line 328: ,ar_cash_receipts cr

324: ,cr.customer_site_use_id --bill_to_site_use_id
325: ,NULL --ship_to_site_use_id
326: ,cr.legal_entity_id
327: FROM ar_payment_schedules ps
328: ,ar_cash_receipts cr
329: ,ar_cash_receipt_history crh
330: WHERE ps.payment_schedule_id = p_receipt_ps_id
331: AND cr.cash_receipt_id = ps.cash_receipt_id
332: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 342: ,ar_cash_receipts cr

338: ) IS
339: SELECT ps.cash_receipt_id --cash_receipt_id
340: ,cr.receipt_number --receipt_number
341: FROM ar_payment_schedules ps
342: ,ar_cash_receipts cr
343: WHERE ps.payment_schedule_id = p_receipt_ps_id
344: AND cr.cash_receipt_id = ps.cash_receipt_id;
345:
346: --Fetch Receivable application info required for subsequent receipt application

Line 476: l_currency_code ar_cash_receipts.currency_code%type;

472: );
473: claim_rec ra_claim_rec_type;
474: claim_rec_null ra_claim_rec_type;
475:
476: l_currency_code ar_cash_receipts.currency_code%type;
477: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%type;
478: l_exchange_rate ar_cash_receipts.exchange_rate%type;
479: l_exchange_date ar_cash_receipts.exchange_date%type;
480: l_customer_id ar_cash_receipts.pay_from_customer%type;

Line 477: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%type;

473: claim_rec ra_claim_rec_type;
474: claim_rec_null ra_claim_rec_type;
475:
476: l_currency_code ar_cash_receipts.currency_code%type;
477: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%type;
478: l_exchange_rate ar_cash_receipts.exchange_rate%type;
479: l_exchange_date ar_cash_receipts.exchange_date%type;
480: l_customer_id ar_cash_receipts.pay_from_customer%type;
481: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%type;

Line 478: l_exchange_rate ar_cash_receipts.exchange_rate%type;

474: claim_rec_null ra_claim_rec_type;
475:
476: l_currency_code ar_cash_receipts.currency_code%type;
477: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%type;
478: l_exchange_rate ar_cash_receipts.exchange_rate%type;
479: l_exchange_date ar_cash_receipts.exchange_date%type;
480: l_customer_id ar_cash_receipts.pay_from_customer%type;
481: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%type;
482: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%type;

Line 479: l_exchange_date ar_cash_receipts.exchange_date%type;

475:
476: l_currency_code ar_cash_receipts.currency_code%type;
477: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%type;
478: l_exchange_rate ar_cash_receipts.exchange_rate%type;
479: l_exchange_date ar_cash_receipts.exchange_date%type;
480: l_customer_id ar_cash_receipts.pay_from_customer%type;
481: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%type;
482: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%type;
483: l_receipt_number ar_cash_receipts.receipt_number%type;

Line 480: l_customer_id ar_cash_receipts.pay_from_customer%type;

476: l_currency_code ar_cash_receipts.currency_code%type;
477: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%type;
478: l_exchange_rate ar_cash_receipts.exchange_rate%type;
479: l_exchange_date ar_cash_receipts.exchange_date%type;
480: l_customer_id ar_cash_receipts.pay_from_customer%type;
481: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%type;
482: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%type;
483: l_receipt_number ar_cash_receipts.receipt_number%type;
484: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%type;

Line 481: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%type;

477: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%type;
478: l_exchange_rate ar_cash_receipts.exchange_rate%type;
479: l_exchange_date ar_cash_receipts.exchange_date%type;
480: l_customer_id ar_cash_receipts.pay_from_customer%type;
481: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%type;
482: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%type;
483: l_receipt_number ar_cash_receipts.receipt_number%type;
484: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%type;
485: l_amount_due_remaining ar_payment_schedules_all.amount_due_remaining%type;

Line 482: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%type;

478: l_exchange_rate ar_cash_receipts.exchange_rate%type;
479: l_exchange_date ar_cash_receipts.exchange_date%type;
480: l_customer_id ar_cash_receipts.pay_from_customer%type;
481: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%type;
482: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%type;
483: l_receipt_number ar_cash_receipts.receipt_number%type;
484: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%type;
485: l_amount_due_remaining ar_payment_schedules_all.amount_due_remaining%type;
486: l_amount_due_original ar_payment_schedules_all.amount_due_original%type;

Line 483: l_receipt_number ar_cash_receipts.receipt_number%type;

479: l_exchange_date ar_cash_receipts.exchange_date%type;
480: l_customer_id ar_cash_receipts.pay_from_customer%type;
481: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%type;
482: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%type;
483: l_receipt_number ar_cash_receipts.receipt_number%type;
484: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%type;
485: l_amount_due_remaining ar_payment_schedules_all.amount_due_remaining%type;
486: l_amount_due_original ar_payment_schedules_all.amount_due_original%type;
487: l_class ar_payment_schedules_all.class%type;

Line 484: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%type;

480: l_customer_id ar_cash_receipts.pay_from_customer%type;
481: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%type;
482: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%type;
483: l_receipt_number ar_cash_receipts.receipt_number%type;
484: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%type;
485: l_amount_due_remaining ar_payment_schedules_all.amount_due_remaining%type;
486: l_amount_due_original ar_payment_schedules_all.amount_due_original%type;
487: l_class ar_payment_schedules_all.class%type;
488: l_claim_amount NUMBER;

Line 505: l_applied_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;

501: l_trx_claim_type VARCHAR2(1); --'O'=Over Pay Claim;; 'S'=Short Pay Claim
502: l_applied_date ar_receivable_applications.apply_date%TYPE;
503: l_applied_action_type VARCHAR2(1);
504: l_amount_applied ar_receivable_applications.amount_applied%TYPE;
505: l_applied_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
506: l_applied_receipt_number ar_cash_receipts.receipt_number%TYPE;
507: l_object_version_number NUMBER;
508: l_claim_reason_code_id NUMBER;
509: l_claim_reason_name VARCHAR2(255);

Line 506: l_applied_receipt_number ar_cash_receipts.receipt_number%TYPE;

502: l_applied_date ar_receivable_applications.apply_date%TYPE;
503: l_applied_action_type VARCHAR2(1);
504: l_amount_applied ar_receivable_applications.amount_applied%TYPE;
505: l_applied_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
506: l_applied_receipt_number ar_cash_receipts.receipt_number%TYPE;
507: l_object_version_number NUMBER;
508: l_claim_reason_code_id NUMBER;
509: l_claim_reason_name VARCHAR2(255);
510: l_active_claim_flag ar_payment_schedules.active_claim_flag%TYPE;

Line 2210: (p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE) RETURN NUMBER IS

2206: | DD-MON-YYYY Name Bug #####, modified amount ..
2207: |
2208: *=======================================================================*/
2209: FUNCTION GET_RECEIVABLES_TRX_ID
2210: (p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE) RETURN NUMBER IS
2211:
2212: l_receivables_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
2213:
2214: BEGIN

Line 2225: FROM ar_receipt_method_accounts rma, ar_cash_receipts cr

2221: INTO l_receivables_trx_id
2222: FROM ar_receivables_trx rt
2223: WHERE rt.receivables_trx_id = (
2224: SELECT rma.claim_receivables_trx_id
2225: FROM ar_receipt_method_accounts rma, ar_cash_receipts cr
2226: WHERE rma.receipt_method_id = cr.receipt_method_id
2227: AND cr.cash_receipt_id = p_cash_receipt_id
2228: AND rma.primary_flag = 'Y' );
2229:

Line 2669: | number by joining to ar_cash_receipts

Line 2690: (p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

2686: | local variable l_application_ref_num
2687: |
2688: *=======================================================================*/
2689: PROCEDURE apply_open_receipt_cover
2690: (p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2691: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE
2692: ,p_open_rec_app_id IN
2693: ar_receivable_applications.receivable_application_id%TYPE
2694: ,p_amount_applied IN

Line 2714: ,x_receipt_number OUT NOCOPY ar_cash_receipts.receipt_number%TYPE

2710: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
2711: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
2712: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
2713: ,x_return_status OUT NOCOPY VARCHAR2
2714: ,x_receipt_number OUT NOCOPY ar_cash_receipts.receipt_number%TYPE
2715: ,x_apply_type OUT NOCOPY VARCHAR2
2716: ) IS
2717:
2718: --Fetch open_cash_receipt_id

Line 2723: ,ar_cash_receipts cr

2719: CURSOR get_open_cr_id
2720: (p_applied_ps_id ar_payment_schedules.payment_schedule_id%TYPE) IS
2721: SELECT ps.cash_receipt_id, cr.receipt_number
2722: FROM ar_payment_schedules ps
2723: ,ar_cash_receipts cr
2724: WHERE ps.payment_schedule_id = p_applied_ps_id
2725: AND ps.cash_receipt_id = cr.cash_receipt_id;
2726:
2727: --Fetch from receivable application if application is valid

Line 2755: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;

2751: l_msg_data VARCHAR2(2000);
2752: l_called_from VARCHAR2(255) := 'ARCABP'; --PostBatch Pro*C
2753: l_process VARCHAR2(1); --'Y'=Process 'N'=Stop Process
2754: l_amount_applied ar_receivable_applications.amount_applied%TYPE;
2755: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2756: l_open_receipt_number ar_cash_receipts.receipt_number%type;
2757: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
2758: l_receivable_application_id ar_receivable_applications.application_ref_num%TYPE;
2759: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;

Line 2756: l_open_receipt_number ar_cash_receipts.receipt_number%type;

2752: l_called_from VARCHAR2(255) := 'ARCABP'; --PostBatch Pro*C
2753: l_process VARCHAR2(1); --'Y'=Process 'N'=Stop Process
2754: l_amount_applied ar_receivable_applications.amount_applied%TYPE;
2755: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2756: l_open_receipt_number ar_cash_receipts.receipt_number%type;
2757: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
2758: l_receivable_application_id ar_receivable_applications.application_ref_num%TYPE;
2759: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
2760: l_acctd_amount_applied_from NUMBER;