SELECT RegimeTLEO.TAX_REGIME_CODE,
RegimeTLEO.TAX_REGIME_ID,
RegimeTLEO.TAX_REGIME_NAME,
RegimeTLEO.EFFECTIVE_FROM,
RegimeTLEO.EFFECTIVE_TO,
RegimeTLEO.HAS_SUB_REGIME_FLAG,
(DECODE (HAS_SUB_REGIME_FLAG, 'Y', 'ViewDisabled', 'View'))
AS VIEW_SWITCHER_ATTR,
FND_TERRITORIES_VL.TERRITORY_SHORT_NAME AS CountryCode,
NULL AS GeographyType,
NULL AS GeographyName,
DECODE (FND_PROFILE.VALUE ('ZX_GCO_WRITE_ACCESS'),
'Y', 'Update',
'UpdateDisabled')
AS UPDATE_SWITCHER_ATTR
FROM ZX_REGIMES_VL RegimeTLEO, FND_TERRITORIES_VL
WHERE 1=1
AND UPPER (RegimeTLEO.TAX_REGIME_CODE) LIKE :2 --Tax Regime Code
AND RegimeTLEO.COUNTRY_OR_GROUP_CODE = 'COUNTRY'
AND FND_TERRITORIES_VL.TERRITORY_CODE = RegimeTLEO.COUNTRY_CODE(+)
RegimeTLEO.TAX_REGIME_ID,
RegimeTLEO.TAX_REGIME_NAME,
RegimeTLEO.EFFECTIVE_FROM,
RegimeTLEO.EFFECTIVE_TO,
RegimeTLEO.HAS_SUB_REGIME_FLAG,
(DECODE (HAS_SUB_REGIME_FLAG, 'Y', 'ViewDisabled', 'View'))
AS VIEW_SWITCHER_ATTR,
FND_TERRITORIES_VL.TERRITORY_SHORT_NAME AS CountryCode,
NULL AS GeographyType,
NULL AS GeographyName,
DECODE (FND_PROFILE.VALUE ('ZX_GCO_WRITE_ACCESS'),
'Y', 'Update',
'UpdateDisabled')
AS UPDATE_SWITCHER_ATTR
FROM ZX_REGIMES_VL RegimeTLEO, FND_TERRITORIES_VL
WHERE 1=1
AND UPPER (RegimeTLEO.TAX_REGIME_CODE) LIKE :2 --Tax Regime Code
AND RegimeTLEO.COUNTRY_OR_GROUP_CODE = 'COUNTRY'
AND FND_TERRITORIES_VL.TERRITORY_CODE = RegimeTLEO.COUNTRY_CODE(+)
No comments:
Post a Comment