FND Design Data [Home] [Help]

View: PA_OUTPUT_TAX_CODE_SETUP_ALL_V

Product: PA - Projects
Description: 10SC Only
Implementation/DBA Data: ViewAPPS.PA_OUTPUT_TAX_CODE_SETUP_ALL_V
View Text

SELECT DISTINCT L.TAX_CODE
, L.PRINTED_TAX_NAME
, L.TAX_RATE
FROM AR_VAT_TAX_ALL_VL L
WHERE SYSDATE BETWEEN L.START_DATE
AND NVL(L.END_DATE
, SYSDATE)
AND NVL(L.ENABLED_FLAG
, 'Y') = 'Y'
AND NVL(L.TAX_CLASS
, 'O') = 'O'
AND NVL(L.DISPLAYED_FLAG
, 'Y') = 'Y'

Columns

Name
TAX_CODE
PRINTED_TAX_NAME
TAX_RATE