APPS.AR_TRX_SUMMARY_PKG dependencies on AR_CASH_RECEIPTS_ALL

Line 217: FROM AR_CASH_RECEIPTS_ALL CR

213: NVL(CR.CUSTOMER_SITE_USE_ID,-99) CUSTOMER_SITE_USE_ID,
214: CR.CURRENCY_CODE CURRENCY,
215: CR.ORG_ID,
216: MAX(CR.RECEIPT_DATE) LAST_CASH_RECEIPT_DATE
217: FROM AR_CASH_RECEIPTS_ALL CR
218: WHERE NVL(CR.CONFIRMED_FLAG, 'Y') = 'Y'
219: AND CR.REVERSAL_DATE IS NULL
220: AND CR.PAY_FROM_CUSTOMER > 0
221: AND CR.TYPE = 'CASH'

Line 226: ar_cash_receipts_all b

222: GROUP BY CR.PAY_FROM_CUSTOMER,
223: NVL(CR.CUSTOMER_SITE_USE_ID,-99),
224: CR.CURRENCY_CODE,
225: CR.ORG_ID) a,
226: ar_cash_receipts_all b
227: where a.last_cash_receipt_date = b.receipt_date
228: and a.CUSTOMER_id = b.pay_from_customer
229: and a.customer_site_use_id = nvl(b.customer_site_use_id,-99)
230: and a.currency = b.currency_code

Line 236: AR_CASH_RECEIPTS_ALL B

232: group by a.customer_id,
233: a.customer_site_use_id,
234: a.currency,
235: a.org_id) a1,
236: AR_CASH_RECEIPTS_ALL B
237: WHERE a1.LAST_CASH_RECEIPT_ID = B.CASH_RECEIPT_ID
238: UNION ALL
239: SELECT CR.PAY_FROM_CUSTOMER CUSTOMER_ID,
240: NVL(CR.CUSTOMER_SITE_USE_ID,-99) CUSTOMER_SITE_USE_ID,

Line 268: FROM AR_CASH_RECEIPTS_ALL CR,

264: 0 LAST_RECEIPT_AMOUNT,
265: TO_DATE(NULL) LAST_RECEIPT_DATE,
266: NULL LAST_RECEIPT_NUMBER,
267: 0 PENDING_ADJ_AMT
268: FROM AR_CASH_RECEIPTS_ALL CR,
269: AR_CASH_RECEIPT_HISTORY_ALL CRH,
270: AR_RECEIVABLE_APPLICATIONS_ALL RAP
271: WHERE NVL(CR.CONFIRMED_FLAG, 'Y') = 'Y'
272: AND CR.REVERSAL_DATE IS NULL

Line 548: from ar_cash_receipts_all cr,

544: 0 unedisc_count,
545: 0 app_amt_days_late,
546: 0 adj_amount,
547: 0 adj_count
548: from ar_cash_receipts_all cr,
549: ar_cash_receipt_history_all crh
550: where cr.cash_receipt_id = crh.cash_receipt_id
551: and crh.current_record_flag = 'Y'
552: and crh.status = 'REVERSED'