View: AR_NET_REVENUE_AMOUNT

Product:	AR - Receivables
Description:	Determine the uncredited amount on a transaction line
Implementation/DBA Data:	APPS.AR_NET_REVENUE_AMOUNT

View Text

SELECT ORIG_CTL.CUSTOMER_TRX_LINE_ID /* CUSTOMER_TRX_LINE_ID */
, ORIG_CTL.CUSTOMER_TRX_ID
, SUM( DECODE(CT.COMPLETE_FLAG
, 'N'
, 0
, CTL.EXTENDED_AMOUNT ) ) /* NET_AMOUNT */
, ORIG_CTL.LINE_TYPE
, SUM( DECODE(CT.COMPLETE_FLAG
, 'N'
, 0
, CTL.GROSS_EXTENDED_AMOUNT) ) /*GROSS_EXTENDED_AMOUNT */
FROM RA_CUSTOMER_TRX_LINES CTL
, RA_CUSTOMER_TRX CT
, RA_CUSTOMER_TRX_LINES ORIG_CTL
WHERE ( CTL.CUSTOMER_TRX_LINE_ID = ORIG_CTL.CUSTOMER_TRX_LINE_ID OR ( CTL.PREVIOUS_CUSTOMER_TRX_LINE_ID = ORIG_CTL.CUSTOMER_TRX_LINE_ID
AND CTL.PREVIOUS_CUSTOMER_TRX_LINE_ID IS NOT NULL ) )
AND CTL.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID GROUP BY ORIG_CTL.CUSTOMER_TRX_LINE_ID
, ORIG_CTL.CUSTOMER_TRX_ID
, /* 6497253 */ ORIG_CTL.LINE_TYPE

Columns