View: ASO_I_TAX_CODES_V

Product:	ASO - Order Capture
Description:	view gives information of all the tax codes recognized by AR
Implementation/DBA Data:	APPS.ASO_I_TAX_CODES_V

View Text

SELECT V.TAX_CODE
, V.TAX_RATE
, V.START_DATE
, V.END_DATE
, V.TAX_TYPE
FROM AR_VAT_TAX V
, AR_SYSTEM_PARAMETERS P
WHERE V.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
AND ((P.TAX_METHOD != 'SALES_TAX'
AND V.TAX_TYPE != 'LOCATION') OR(P.TAX_METHOD = 'SALES_TAX'))

Columns