VIEW: APPS.AR_RECEIPT_AMOUNTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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