Wednesday, November 8, 2017

Query to get Tax Regime Details in Oracle Apps

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(+)

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)