VIEW: APPS.AR_INVOICE_TOTALS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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