View: AR_RECEIPT_AMOUNTS_V

Product:	AR - Receivables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.AR_RECEIPT_AMOUNTS_V

View Text

SELECT CR.CASH_RECEIPT_ID
, CR.RECEIPT_NUMBER
, CR.RECEIPT_DATE
, CR.CURRENCY_CODE
, RM.NAME METHOD
, DECODE(CR.TYPE
, 'MISC'
, NULL
, NVL(SUM(DECODE(RA.STATUS
, 'APP'
, NVL(RA.AMOUNT_APPLIED
, 0)
, 0))
, 0)) APPLIED_AMOUNT
, DECODE(CR.TYPE
, 'MISC'
, NULL
, NVL(SUM(DECODE(RA.STATUS
, 'UNAPP'
, NVL(RA.AMOUNT_APPLIED
, 0)
, 0))
, 0)) UNAPPLIED_AMOUNT
, DECODE(CR.TYPE
, 'MISC'
, NULL
, NVL(SUM(DECODE(RA.STATUS
, 'ACC'
, NVL(RA.AMOUNT_APPLIED
, 0)
, 0))
, 0)) ON_ACCOUNT_AMOUNT
, DECODE(CR.TYPE
, 'MISC'
, NULL
, NVL(SUM(DECODE(RA.STATUS
, 'UNID'
, NVL(RA.AMOUNT_APPLIED
, 0)
, 0))
, 0)) UNIDENTIFIED_AMOUNT
FROM AR_RECEIVABLE_APPLICATIONS RA
, AR_CASH_RECEIPTS CR
, AR_RECEIPT_METHODS RM
WHERE RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
AND CR.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID GROUP BY CR.CASH_RECEIPT_ID
, CR.RECEIPT_DATE
, CR.RECEIPT_NUMBER
, RM.NAME
, CR.CURRENCY_CODE
, CR.TYPE

Columns