APPS.ARI_UTILITIES dependencies on RA_CM_REQUESTS

Line 2842: FROM ra_cm_requests

2838: END IF;
2839:
2840: SELECT total_amount * -1
2841: INTO remove_from_dispute_amt
2842: FROM ra_cm_requests
2843: WHERE request_id = p_dispute_id;
2844:
2845: FOR ps_rec IN ps_cur(l_customer_trx_id)
2846: LOOP

Line 2897: FROM ra_cm_requests

2893:
2894: if l_customer_trx_id is null then
2895: SELECT customer_trx_id
2896: INTO l_customer_trx_id
2897: FROM ra_cm_requests
2898: WHERE request_id = l_document_id;
2899: end if;
2900:
2901: l_notes := wf_engine.getitemattrtext(l_item_type, p_dispute_id, 'NOTES');

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