View: AR_LL_SUMMARY_V

Product:	AR - Receivables
Description:	Summary for Line-Level Cash Application
Implementation/DBA Data:	APPS.AR_LL_SUMMARY_V

View Text

SELECT CASH_RECEIPT_ID
, AD.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, ALLOCATED_RECEIPT_AMOUNT
, LINE
, TAX
, FREIGHT
, CHARGES
, LIN_DISCOUNT
, TAX_DISCOUNT
, FRT_DISCOUNT
, COMMENTS
, CREATED_BY_MODULE
, OBJECT_VERSION_NUMBER
, LIN_BALANCE
, TAX_BALANCE
, FRT_BALANCE
, CHG_BALANCE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM (SELECT LL.CASH_RECEIPT_ID
, CTL.CUSTOMER_TRX_ID
, SUM(LL.ALLOCATED_RECEIPT_AMOUNT) ALLOCATED_RECEIPT_AMOUNT
, SUM(LL.AMOUNT) LINE
, SUM(LL.TAX) TAX
, SUM(LL.FREIGHT) FREIGHT
, SUM(LL.CHARGES) CHARGES
, SUM(LL.LINE_DISCOUNT) LIN_DISCOUNT
, SUM(LL.TAX_DISCOUNT) TAX_DISCOUNT
, SUM(LL.FREIGHT_DISCOUNT) FRT_DISCOUNT
, MAX(LL.COMMENTS) COMMENTS
, MAX(LL.CREATED_BY_MODULE) CREATED_BY_MODULE
, SUM(LL.OBJECT_VERSION_NUMBER) OBJECT_VERSION_NUMBER
, MAX(LL.LAST_UPDATE_DATE) LAST_UPDATE_DATE
, MAX(LL.LAST_UPDATED_BY) LAST_UPDATED_BY
, MAX(LL.CREATION_DATE) CREATION_DATE
, MAX(LL.CREATED_BY) CREATED_BY
, MAX(LL.LAST_UPDATE_LOGIN) LAST_UPDATE_LOGIN
FROM AR_ACTIVITY_DETAILS LL
, RA_CUSTOMER_TRX_LINES CTL
WHERE NVL(LL.SOURCE_TABLE
, 'RA') = 'RA'
AND NVL(LL.CURRENT_ACTIVITY_FLAG
, 'Y') = 'Y'
AND CTL.CUSTOMER_TRX_LINE_ID = LL.CUSTOMER_TRX_LINE_ID GROUP BY LL.CASH_RECEIPT_ID
, CTL.CUSTOMER_TRX_ID) AD
, (SELECT SUM(DECODE(LINE_TYPE
, 'LINE'
, AMOUNT_DUE_REMAINING
, 0)) LIN_BALANCE
, SUM(DECODE(LINE_TYPE
, 'TAX'
, AMOUNT_DUE_REMAINING
, 0)) TAX_BALANCE
, SUM(DECODE(LINE_TYPE
, 'LINE'
, FRT_ADJ_REMAINING
, 'FREIGHT'
, AMOUNT_DUE_REMAINING
, 0)) FRT_BALANCE
, SUM(DECODE(LINE_TYPE
, 'LINE'
, CHRG_AMOUNT_REMAINING
, 'CHARGES'
, AMOUNT_DUE_REMAINING
, 0)) CHG_BALANCE
, CUSTOMER_TRX_ID
FROM RA_CUSTOMER_TRX_LINES GROUP BY CUSTOMER_TRX_ID) LINES
WHERE AD.CUSTOMER_TRX_ID = LINES.CUSTOMER_TRX_ID

Columns