VIEW: APPS.JE_ES_TAX_TYPE_V

Source

View Text - Preformatted

SELECT Zrc.Reporting_Code_Char_Value, Zrctl.Reporting_Code_Name, Rps1.Vat_Reporting_Entity_Id , Rps1.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, jg_zz_vat_rep_entities rps1 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(rps1.mapping_vat_Rep_entity_id,rps1.vat_reporting_entity_id) = rps.vat_reporting_entity_id AND rps.Tax_Regime_Code = nvl(zrt.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'

View Text - HTML Formatted

SELECT ZRC.REPORTING_CODE_CHAR_VALUE
, ZRCTL.REPORTING_CODE_NAME
, RPS1.VAT_REPORTING_ENTITY_ID
, RPS1.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
, JG_ZZ_VAT_REP_ENTITIES RPS1
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(RPS1.MAPPING_VAT_REP_ENTITY_ID
, RPS1.VAT_REPORTING_ENTITY_ID) = RPS.VAT_REPORTING_ENTITY_ID
AND RPS.TAX_REGIME_CODE = NVL(ZRT.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'