VIEW: APPS.SO_TAX_CODES_V

Source

View Text - Preformatted

SELECT V.TAX_CODE "TAX_CODE" , V.TAX_RATE "TAX_RATE" , V.START_DATE "START_DATE" , V.END_DATE "END_DATE" , V.TAX_TYPE "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' )) and nvl(ENABLED_FLAG,'Y') = 'Y' and nvl(tax_class,'O') = 'O' and nvl(displayed_flag,'Y') = 'Y'

View Text - HTML Formatted

SELECT V.TAX_CODE "TAX_CODE"
, V.TAX_RATE "TAX_RATE"
, V.START_DATE "START_DATE"
, V.END_DATE "END_DATE"
, V.TAX_TYPE "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' ))
AND NVL(ENABLED_FLAG
, 'Y') = 'Y'
AND NVL(TAX_CLASS
, 'O') = 'O'
AND NVL(DISPLAYED_FLAG
, 'Y') = 'Y'