VIEW: APPS.AR_INVOICE_TAX_SUMMARY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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