APPS.AR_TRX_SUMMARY_PKG dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 332: AR_CASH_RECEIPT_HISTORY_ALL CRH

328: FROM DUAL
329: WHERE EXISTS (
330: SELECT 'at risk receipt'
331: FROM AR_CASH_RECEIPTS_ALL CR,
332: AR_CASH_RECEIPT_HISTORY_ALL CRH
333: WHERE NVL(CR.CONFIRMED_FLAG, 'Y') = 'Y'
334: AND CR.REVERSAL_DATE IS NULL
335: AND CR.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
336: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 361: AR_CASH_RECEIPT_HISTORY_ALL CRH,

357: CR.ORG_ID ORG_ID,
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

Line 663: ar_cash_receipt_history_all crh

659: 0 app_amt_days_late,
660: 0 adj_amount,
661: 0 adj_count
662: from ar_cash_receipts_all cr,
663: ar_cash_receipt_history_all crh
664: where cr.cash_receipt_id = crh.cash_receipt_id
665: and crh.current_record_flag = 'Y'
666: and crh.status = 'REVERSED'
667: and crh.creation_date <= l_program_start_date

Line 1593: AR_CASH_RECEIPT_HISTORY_ALL CRH,

1589: TO_DATE(NULL) LAST_RECEIPT_DATE,
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

Line 1876: ar_cash_receipt_history_all crh

1872: 0 app_amt_days_late,
1873: 0 adj_amount,
1874: 0 adj_count
1875: from ar_cash_receipts_all cr,
1876: ar_cash_receipt_history_all crh
1877: where cr.cash_receipt_id = crh.cash_receipt_id
1878: and crh.current_record_flag = 'Y'
1879: and crh.status = 'REVERSED'
1880: and cr.status = 'REV'