APPS.AR_TRX_SUMMARY_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 362: AR_RECEIVABLE_APPLICATIONS_ALL RAP

358: SUM(DECODE(RAP.APPLIED_PAYMENT_SCHEDULE_ID,-2,NULL,
359: CRH.AMOUNT)) RECEIPTS_AT_RISK_VALUE
360: FROM AR_CASH_RECEIPTS_ALL CR,
361: AR_CASH_RECEIPT_HISTORY_ALL CRH,
362: AR_RECEIVABLE_APPLICATIONS_ALL RAP
363: WHERE NVL(CR.CONFIRMED_FLAG, 'Y') = 'Y'
364: AND CR.REVERSAL_DATE IS NULL
365: AND CR.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
366: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 592: AR_RECEIVABLE_APPLICATIONS_ALL RA

588: sum(decode(ps.class, 'INV',
589: decode(ra.unearned_discount_taken,0,
590: null,ra.unearned_discount_taken), null)) unedisc_taken
591: FROM AR_PAYMENT_SCHEDULES_all ps,
592: AR_RECEIVABLE_APPLICATIONS_ALL RA
593: WHERE RA.APPLIED_PAYMENT_SCHEDULE_ID(+) = PS.PAYMENT_SCHEDULE_ID
594: AND RA.CREATION_DATE(+) <= l_program_start_date
595: AND RA.DISPLAY(+) = 'Y'
596: AND RA.STATUS(+) = 'APP'

Line 732: ar_receivable_applications_all ra

728: sum(decode(ps.class, 'INV',
729: (ra.apply_date - ps.due_date)* ra.amount_applied, null)) app_amt_days_late
730: from ar_payment_schedules_all ps,
731: ra_terms_b rt,
732: ar_receivable_applications_all ra
733: where ps.payment_schedule_id = ra.applied_payment_schedule_id
734: and ps.customer_id > 0
735: and ps.term_id = rt.term_id(+)
736: and ra.creation_date <= l_program_start_date

Line 994: ar_receivable_applications_all ra

990: sum(-ra.amount_applied
991: -nvl(ra.earned_discount_taken,0)
992: -nvl(ra.unearned_discount_taken,0)) net_amount
993: from ar_payment_schedules_all ps,
994: ar_receivable_applications_all ra
995: where ps.payment_schedule_id = ra.applied_payment_schedule_id
996: and ps.customer_id > 0
997: and ra.status = '||''''||'APP'||''''||'
998: and ra.application_type = '||''''||'CASH'||''''||'

Line 1594: AR_RECEIVABLE_APPLICATIONS_ALL RAP

1590: NULL LAST_RECEIPT_NUMBER,
1591: 0 PENDING_ADJ_AMT
1592: FROM AR_CASH_RECEIPTS_ALL CR,
1593: AR_CASH_RECEIPT_HISTORY_ALL CRH,
1594: AR_RECEIVABLE_APPLICATIONS_ALL RAP
1595: WHERE NVL(CR.CONFIRMED_FLAG, 'Y') = 'Y'
1596: AND CR.REVERSAL_DATE IS NULL
1597: AND CR.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
1598: AND CR.PAY_FROM_CUSTOMER = p_cust_id(i)

Line 1808: AR_RECEIVABLE_APPLICATIONS_ALL RA

1804: sum(decode(ps.class, 'INV',
1805: decode(ra.unearned_discount_taken,0,
1806: null,ra.unearned_discount_taken), null)) unedisc_taken
1807: FROM AR_PAYMENT_SCHEDULES_all ps,
1808: AR_RECEIVABLE_APPLICATIONS_ALL RA
1809: WHERE RA.APPLIED_PAYMENT_SCHEDULE_ID(+) = PS.PAYMENT_SCHEDULE_ID
1810: AND RA.DISPLAY(+) = 'Y'
1811: AND RA.STATUS(+) = 'APP'
1812: AND PS.CUSTOMER_ID = p_cust_id(i)

Line 1944: ar_receivable_applications_all ra

1940: sum(decode(ps.class, 'INV',
1941: (ra.apply_date - ps.due_date) * ra.amount_applied, null)) app_amt_days_late
1942: from ar_payment_schedules_all ps,
1943: ra_terms_b rt,
1944: ar_receivable_applications_all ra
1945: where ps.payment_schedule_id = ra.applied_payment_schedule_id
1946: and ps.customer_id = p_cust_id(i)
1947: and ps.term_id = rt.term_id(+)
1948: and ra.status = 'APP'

Line 2217: ar_receivable_applications_all ra

2213: sum(-ra.amount_applied
2214: -nvl(ra.earned_discount_taken,0)
2215: -nvl(ra.unearned_discount_taken,0)) net_amount
2216: from ar_payment_schedules_all ps,
2217: ar_receivable_applications_all ra
2218: where ps.payment_schedule_id = ra.applied_payment_schedule_id
2219: and ps.customer_id in (select customer_id from cust_list)
2220: and ra.status = '||''''||'APP'||''''||'
2221: and ra.application_type = '||''''||'CASH'||''''||'