FND Design Data [Home] [Help]

View: JAI_REGIME_TAX_TYPES_V

Product: JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data: ViewAPPS.JAI_REGIME_TAX_TYPES_V
View Text

SELECT ATTRIBUTE_CODE TAX_TYPE
, REGIME_CODE
, AA.REGIME_ID
FROM JAI_RGM_REGISTRATIONS AA
, JAI_RGM_DEFINITIONS BB
WHERE AA.REGIME_ID = BB.REGIME_ID
AND AA.REGISTRATION_TYPE = 'TAX_TYPES'
AND UPPER(AA.ATTRIBUTE_CODE) <> 'VAT REVERSAL'

Columns

Name
TAX_TYPE
REGIME_CODE
REGIME_ID