View: AR_LL_FREIGHT_CHARGES_V

Product:	AR - Receivables
Description:	The AR_LL_LINES_GROUPS_V view is used by the Line-Level Cash Application form
Implementation/DBA Data:	APPS.AR_LL_FREIGHT_CHARGES_V

View Text

SELECT CASH_RECEIPT_ID
, MIN(CUSTOMER_TRX_LINE_ID) CUSTOMER_TRX_LINE_ID
, SUM(ALLOCATED_RECEIPT_AMOUNT) ALLOCATED_RECEIPT_AMOUNT
, SUM(AMOUNT) AMOUNT
, SUM(FREIGHT_AMOUNT) FREIGHT_AMOUNT
, SUM(CHARGES_AMOUNT) CHARGES_AMOUNT
, MAX(LAST_UPDATE_DATE) LAST_UPDATE_DATE
, MAX(LAST_UPDATED_BY) LAST_UPDATED_BY
, SUM(LINE_DISCOUNT) LINE_DISCOUNT
, MAX(CREATION_DATE) CREATION_DATE
, MAX(CREATED_BY) CREATED_BY
, MAX(LAST_UPDATE_LOGIN) LAST_UPDATE_LOGIN
, MAX(COMMENTS) COMMENTS
, APPLY_TO
, MAX(CREATED_BY_MODULE) CREATED_BY_MODULE
, MIN(OBJECT_VERSION_NUMBER) OBJECT_VERSION_NUMBER
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, MIN(LINE_NUMBER) LINE_NUMBER
, SUM(LINE_BALANCE) LINE_BALANCE
FROM ( SELECT LL.CASH_RECEIPT_ID
, LL.CUSTOMER_TRX_LINE_ID
, LL.ALLOCATED_RECEIPT_AMOUNT
, DECODE (LINE.LINE_TYPE
, 'FREIGHT'
, LL.FREIGHT
, 'CHARGES'
, LL.CHARGES) AMOUNT
, LL.FREIGHT FREIGHT_AMOUNT
, LL.CHARGES CHARGES_AMOUNT
, LL.LAST_UPDATE_DATE
, LL.LAST_UPDATED_BY
, LL.FREIGHT_DISCOUNT LINE_DISCOUNT
, LL.CREATION_DATE
, LL.CREATED_BY
, LL.LAST_UPDATE_LOGIN
, LL.COMMENTS
, TO_CHAR(LL.APPLY_TO) APPLY_TO
, LL.CREATED_BY_MODULE
, LL.OBJECT_VERSION_NUMBER
, LINE.CUSTOMER_TRX_ID
, LINE.LINE_NUMBER LINE_NUMBER
, LINE.AMOUNT_DUE_REMAINING LINE_BALANCE
FROM AR_ACTIVITY_DETAILS LL
, RA_CUSTOMER_TRX_LINES LINE
WHERE LINE.CUSTOMER_TRX_LINE_ID = LL.CUSTOMER_TRX_LINE_ID
AND LINE.LINE_TYPE IN ('FREIGHT'
, 'CHARGES')
AND NVL(LL.SOURCE_TABLE
, 'RA') = 'RA'
AND NVL(LL.CURRENT_ACTIVITY_FLAG
, 'Y') = 'Y' /*7241111*/ ) FRTCHG GROUP BY CASH_RECEIPT_ID
, CUSTOMER_TRX_ID
, APPLY_TO

Columns