APPS.ARI_UTILITIES dependencies on RA_CUSTOMER_TRX

Line 2786: from ra_customer_trx

2782: where cust_account_id = p_cust_acct_id;
2783:
2784: Cursor Get_billto(p_cust_trx_id number) Is
2785: select bill_to_site_use_id
2786: from ra_customer_trx
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

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 2980: where ps.CUSTOMER_TRX_ID= ra.CUSTOMER_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
2984: Select (sysdate - TRX_DATE) into l_txn_difference from ar_payment_schedules_all

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