VIEW: APPS.ASO_I_TAX_CODES_V

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))