FND Design Data [Home] [Help]

View: PA_OUTPUT_TAX_REASON_V

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

SELECT LK.LOOKUP_CODE
, LK.MEANING
FROM FND_LOOKUPS LK
WHERE LK.LOOKUP_TYPE = 'ZX_EXEMPTION_REASON_CODE'
AND LK.ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(LK.START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(LK.END_DATE_ACTIVE
, SYSDATE)) ORDER BY MEANING

Columns

Name
TAX_EXEMPT_REASON_CODE
TAX_EXEMPT_REASON