View: AR_INVOICE_TOTALS_V

Product:	AR - Receivables
Description:	Collects the total amount of charges for a transaction
Implementation/DBA Data:	APPS.AR_INVOICE_TOTALS_V

View Text

SELECT SUM( DECODE( LINE_TYPE
, 'TAX'
, EXTENDED_AMOUNT
, 0 ) ) TOTAL_TAX_AMOUNT
, SUM( DECODE( LINE_TYPE
, 'FREIGHT'
, EXTENDED_AMOUNT
, 0 ) ) TOTAL_FREIGHT_AMOUNT
, SUM( DECODE( LINE_TYPE
, 'FREIGHT'
, 0
, 'TAX'
, 0
, EXTENDED_AMOUNT ) ) TOTAL_LINE_AMOUNT
, SUM( EXTENDED_AMOUNT) TOTAL_AMOUNT
, TRX.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
FROM RA_CUSTOMER_TRX_LINES LINES
, RA_CUST_TRX_TYPES TYPES
, RA_CUSTOMER_TRX TRX
WHERE TRX.COMPLETE_FLAG = 'Y'
AND TRX.CUSTOMER_TRX_ID = LINES.CUSTOMER_TRX_ID
AND TRX.CUST_TRX_TYPE_ID = TYPES.CUST_TRX_TYPE_ID
AND TYPES.DEFAULT_PRINTING_OPTION = 'PRI' GROUP BY TRX.CUSTOMER_TRX_ID

Columns