View: AR_TAX_SUMM_V

Product:	AR - Receivables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.AR_TAX_SUMM_V

View Text

SELECT CTL_TAX.TAX_PRECEDENCE
, VAT.TAX_CODE
, CTL_TAX.AMOUNT_INCLUDES_TAX_FLAG
, CTL_TAX.TAX_RATE
, CTL_TAX.CUSTOMER_TRX_ID
, SUM(CTL_TAX.EXTENDED_AMOUNT)
FROM RA_CUSTOMER_TRX_LINES CTL_INV_LINE
, RA_CUSTOMER_TRX_LINES CTL_INV_TAX
, AR_VAT_TAX INV_VAT
, RA_CUSTOMER_TRX_LINES CTL_LINE
, RA_CUSTOMER_TRX_LINES CTL_TAX
, AR_VAT_TAX VAT
WHERE CTL_TAX.LINK_TO_CUST_TRX_LINE_ID = CTL_LINE.CUSTOMER_TRX_LINE_ID
AND CTL_TAX.LINE_TYPE = 'TAX'
AND CTL_TAX.VAT_TAX_ID = VAT.VAT_TAX_ID(+)
AND CTL_TAX.PREVIOUS_CUSTOMER_TRX_LINE_ID = CTL_INV_TAX.CUSTOMER_TRX_LINE_ID(+)
AND CTL_INV_TAX.LINK_TO_CUST_TRX_LINE_ID = CTL_INV_LINE.CUSTOMER_TRX_LINE_ID (+)
AND CTL_INV_TAX.VAT_TAX_ID = INV_VAT.VAT_TAX_ID (+) GROUP BY CTL_TAX.TAX_PRECEDENCE
, VAT.TAX_CODE
, CTL_TAX.AMOUNT_INCLUDES_TAX_FLAG
, CTL_TAX.TAX_RATE
, CTL_TAX.CUSTOMER_TRX_ID

Columns