View: AR_INVOICE_TAX_SUMMARY_V

Product:	AR - Receivables
Description:	Collects tax information for transactions
Implementation/DBA Data:	APPS.AR_INVOICE_TAX_SUMMARY_V

View Text

SELECT TRX.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, PROF.TAX_PRINTING_OPTION TAX_PRINTING_OPTION
, LINES.DESCRIPTION DESCRIPTION
, NVL(SUM(LINES.EXTENDED_AMOUNT)
, 0) TAX_AMOUNT
, LINES.TAX_RATE TAX_RATE
, AR_INVOICE_SQL_FUNC_PUB.GET_INV_TAX_CODE_NAME( TRX.SHIP_TO_SITE_USE_ID
, PROF.CUST_ACCOUNT_ID
, PROF.TAX_PRINTING_OPTION
, VAT.PRINTED_TAX_NAME
, VAT.TAX_CODE ) TAX_CODE_NAME
, LINES.TAX_EXEMPTION_ID TAX_EXEMPTION_ID
, LINES.SALES_TAX_ID SALES_TAX_ID
, LINES.TAX_PRECEDENCE TAX_PRECEDENCE
, SUM(LINES2.EXTENDED_AMOUNT) EURO_TAXABLE_AMOUNT
FROM AR_VAT_TAX_VL VAT
, HZ_CUSTOMER_PROFILES PROF
, RA_CUSTOMER_TRX_LINES LINES2
, RA_CUSTOMER_TRX_LINES LINES
, RA_CUSTOMER_TRX TRX
WHERE LINES.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID AND LINES.LINE_TYPE = 'TAX' AND LINES.VAT_TAX_ID = VAT.VAT_TAX_ID(+) AND LINES2.CUSTOMER_TRX_LINE_ID(+) = LINES.LINK_TO_CUST_TRX_LINE_ID AND TRX.SHIP_TO_CUSTOMER_ID = PROF.CUST_ACCOUNT_ID(+)
AND PROF.SITE_USE_ID IS NULL GROUP BY TRX.CUSTOMER_TRX_ID
, PROF.TAX_PRINTING_OPTION
, LINES.DESCRIPTION
, LINES.TAX_RATE
, TRX.SHIP_TO_SITE_USE_ID
, PROF.CUST_ACCOUNT_ID
, PROF.TAX_PRINTING_OPTION
, VAT.PRINTED_TAX_NAME
, VAT.TAX_CODE
, LINES.TAX_EXEMPTION_ID
, LINES.SALES_TAX_ID
, LINES.TAX_PRECEDENCE

Columns