VIEW: APPS.AR_NET_REVENUE_AMOUNT

Source

View Text - Preformatted

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

View Text - HTML Formatted

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