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.ARI_UTILITIES dependencies on AR_PAYMENT_SCHEDULES

Line 2054: select trx_number,CUSTOMER_SITE_USE_ID from ar_payment_schedules where trx_number=p_trx_number

2050: and acct_sites_count.cust_account_id=p_customer_id
2051: and INSTR(ARI_UTILITIES.GET_SITE_USE_CODE(acct_sites_count.CUST_ACCT_SITE_ID), 'BILL_TO')>0;
2052:
2053: select count(*) into l_flag from(
2054: select trx_number,CUSTOMER_SITE_USE_ID from ar_payment_schedules where trx_number=p_trx_number
2055: and CUSTOMER_SITE_USE_ID in
2056: (
2057: select ARI_UTILITIES.get_bill_to_site_use_id(CUST_ACCT_SITE_ID) from ar_sites_assigned_v where
2058: party_id=p_party_id

Line 2126: from ar_payment_schedules_all aps,HZ_CUST_SITE_USES sites

2122: --------------------------------------------------------------------
2123:
2124: select aps.customer_id,sites.CUST_ACCT_SITE_ID,aps.trx_number
2125: into l_customer_id,l_customer_acct_site_id,l_trx_number
2126: from ar_payment_schedules_all aps,HZ_CUST_SITE_USES sites
2127: where aps.customer_trx_id = l_customer_trx_id
2128: and aps.org_id = l_org_id
2129: and sites.site_use_id = aps.customer_site_use_id;
2130:

Line 2576: from ar_payment_schedules_all aps,ra_terms t

2572: ---------------------------------------------------------------------------
2573:
2574: select aps.trx_number,aps.amount_due_original,aps.invoice_currency_code,aps.due_date,t.name,t.description,aps.class
2575: into l_trx_number,l_trx_amt_due,l_trx_curr_code,l_trx_due_date,l_trx_term_name,l_trx_term_desc,l_trx_type
2576: from ar_payment_schedules_all aps,ra_terms t
2577: where aps.trx_number = l_trx_number
2578: and aps.customer_id = p_customer_id
2579: and aps.term_id = t.term_id(+);
2580:

Line 2776: FROM ar_payment_schedules ps

2772: SELECT payment_schedule_id,
2773: due_date,
2774: amount_in_dispute,
2775: dispute_date
2776: FROM ar_payment_schedules ps
2777: WHERE ps.customer_trx_id = p_customer_trx_id;
2778:
2779: cursor get_partyid(p_cust_acct_id number) is
2780: select party_id

Line 2791: from ar_payment_schedules

2787: where customer_trx_id = p_cust_trx_id;
2788:
2789: Cursor Get_paymentid(p_cust_trx_id number) Is
2790: select customer_id,payment_schedule_id
2791: from ar_payment_schedules
2792: where customer_trx_id = p_cust_trx_id;
2793:
2794: l_item_type VARCHAR2(100);
2795: l_customer_trx_id NUMBER;

Line 2971: from ar_payment_schedules_all

2967: BEGIN
2968: p_result := 'N';
2969: if(p_cust_trx_id is null) then
2970: select customer_trx_id into l_cust_trx_id
2971: from ar_payment_schedules_all
2972: where payment_schedule_id = p_payment_schedule_id
2973: and trx_number = p_txn_no;
2974: else
2975: l_cust_trx_id := p_cust_trx_id;

Line 2979: from ar_payment_schedules_all ps, ra_customer_trx_all ra

2975: l_cust_trx_id := p_cust_trx_id;
2976: end if;
2977: if(p_txn_type<>'PMT') THEN
2978: Select (sysdate - ps.TRX_DATE), ra.Printing_option into l_txn_difference, l_print_flag
2979: from ar_payment_schedules_all ps, ra_customer_trx_all ra
2980: where ps.CUSTOMER_TRX_ID= ra.CUSTOMER_TRX_ID
2981: and ps.trx_number=p_txn_no
2982: and ps.CUSTOMER_TRX_ID = l_cust_trx_id;
2983: else

Line 2984: Select (sysdate - TRX_DATE) into l_txn_difference from ar_payment_schedules_all

2980: where ps.CUSTOMER_TRX_ID= ra.CUSTOMER_TRX_ID
2981: and ps.trx_number=p_txn_no
2982: and ps.CUSTOMER_TRX_ID = l_cust_trx_id;
2983: else
2984: Select (sysdate - TRX_DATE) into l_txn_difference from ar_payment_schedules_all
2985: where trx_number=p_txn_no
2986: and PAYMENT_SCHEDULE_ID = p_payment_schedule_id;
2987: end if;
2988: IF (PG_DEBUG = 'Y') THEN

Line 3065: FROM RA_CM_REQUESTS RaCmRequests, AR_PAYMENT_SCHEDULES ArPaymentSchedules, ar_irec_user_acct_sites_all AcctSites, ra_customer_trx ct

3061: end if;
3062:
3063: if(p_customer_id IS NULL OR p_customer_id = -1) then
3064: SELECT /*+ LEADING(RaCmRequests)*/ nvl(sum ( total_amount ), 0) into pending_cmreq_amt
3065: FROM RA_CM_REQUESTS RaCmRequests, AR_PAYMENT_SCHEDULES ArPaymentSchedules, ar_irec_user_acct_sites_all AcctSites, ra_customer_trx ct
3066: WHERE (RaCmRequests.CUSTOMER_TRX_ID = ArPaymentSchedules.CUSTOMER_TRX_ID) AND
3067: nvl(ArPaymentSchedules.terms_sequence_number,1) = 1
3068: AND AcctSites.user_id=FND_GLOBAL.USER_ID()
3069: AND ArPaymentSchedules.customer_id = AcctSites.customer_id

Line 3081: FROM RA_CM_REQUESTS RaCmRequests, AR_PAYMENT_SCHEDULES ArPaymentSchedules, ar_irec_user_acct_sites_all AcctSites, ra_customer_trx ct

3077: AND(TRUNC(ArPaymentSchedules.trx_date)) >= trunc(decode( nvl(FND_PROFILE.VALUE('ARI_FILTER_TRXDATE_OLDER'), 0), 0, ArPaymentSchedules.trx_date, (sysdate-FND_PROFILE.VALUE('ARI_FILTER_TRXDATE_OLDER'))))
3078: AND ct.printing_option = decode(nvl(FND_PROFILE.VALUE('ARI_FILTER_DONOTPRINT_TRX'), 'NOT'), 'Y', 'PRI', ct.printing_option) ;
3079: else
3080: SELECT /*+ LEADING(RaCmRequests)*/ nvl(sum ( total_amount ), 0) into pending_cmreq_amt
3081: FROM RA_CM_REQUESTS RaCmRequests, AR_PAYMENT_SCHEDULES ArPaymentSchedules, ar_irec_user_acct_sites_all AcctSites, ra_customer_trx ct
3082: WHERE (RaCmRequests.CUSTOMER_TRX_ID = ArPaymentSchedules.CUSTOMER_TRX_ID) AND
3083: nvl(ArPaymentSchedules.terms_sequence_number,1) = 1
3084: AND AcctSites.user_id=FND_GLOBAL.USER_ID()
3085: AND ArPaymentSchedules.customer_id=p_customer_id