View: SO_TAX_CODES_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.SO_TAX_CODES_V

View Text

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'

Columns