View: JE_ES_TAX_TYPE_V

Product:	JE - European Localizations
Description:	JE_ES_TAX_TYPE_V View is created for value set JEES_TAX_TYPE for Spanish Output VAT Journal Report.
Implementation/DBA Data:	APPS.JE_ES_TAX_TYPE_V

View Text

SELECT ZRC.REPORTING_CODE_CHAR_VALUE
, ZRCTL.REPORTING_CODE_NAME
, RPS.VAT_REPORTING_ENTITY_ID
, RPS.MAPPING_VAT_REP_ENTITY_ID
, ZRT.TAX_REGIME_CODE
, ZRT.TAX
FROM ZX_REPORTING_TYPES_B ZRT
, ZX_REPORTING_CODES_B ZRC
, ZX_REPORTING_CODES_TL ZRCTL
, JG_ZZ_VAT_REP_ENTITIES RPS
WHERE ZRT.REPORTING_TYPE_CODE = 'EMEA_VAT_REPORTING_TYPE'
AND ZRT.REPORTING_TYPE_ID = ZRC.REPORTING_TYPE_ID
AND ZRC.REPORTING_CODE_ID = ZRCTL.REPORTING_CODE_ID
AND SYSDATE BETWEEN NVL(ZRC.EFFECTIVE_FROM
, SYSDATE)
AND NVL(ZRC.EFFECTIVE_TO
, SYSDATE)AND ZRCTL.LANGUAGE IN USERENV('LANG')
AND NVL(ZRT.TAX_REGIME_CODE
, RPS.TAX_REGIME_CODE) = RPS.TAX_REGIME_CODE UNION SELECT LOOKUP_CODE
, MEANING
, NULL
, NULL
, NULL
, NULL
FROM AR_LOOKUPS
WHERE LOOKUP_TYPE= 'JE_DEFERRED_TAX_TYPE'

Columns