View: ZX_SCO_INPUT_RATES_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ZX_SCO_INPUT_RATES_V

View Text

SELECT RT.TAX_REGIME_CODE TAX_REGIME_CODE
, RTL.TAX_REGIME_NAME TAX_REGIME_NAME
, RT.TAX TAX
, TTL.TAX_FULL_NAME TAX_FULL_NAME
, RT.TAX_STATUS_CODE TAX_STATUS_CODE
, STL.TAX_STATUS_NAME TAX_STATUS_NAME
, RT.TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE
, NULL TAX_JURISDICTION_NAME
, RT.TAX_RATE_CODE TAX_RATE_CODE
, NVL(TL.TAX_RATE_NAME
, RT.TAX_RATE_CODE) TAX_RATE_NAME
, DECODE(RT.RATE_TYPE_CODE
, 'QUANTITY'
, RT.QUANTITY_RATE
, 'PERCENTAGE'
, RT.PERCENTAGE_RATE
, 0) TAX_RATE
, RT.ACTIVE_FLAG ACTIVE_FLAG
, RT.EFFECTIVE_FROM EFFECTIVE_FROM
, RT.EFFECTIVE_TO EFFECTIVE_TO FROM ZX_SCO_RATES RT
, ZX_RATES_TL TL
, ZX_REGIMES_B_V RG
, ZX_REGIMES_TL RTL
, ZX_SCO_TAXES TX
, ZX_TAXES_TL TTL
, ZX_SCO_STATUS ST
, ZX_STATUS_TL STL WHERE RT.TAX_RATE_CODE IN (SELECT LOOKUP_CODE
FROM ZX_INPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = RT.TAX_RATE_CODE AND ORG_ID IN (-99
, (SELECT PARTY_ID
FROM ZX_PARTY_TAX_PROFILE WHERE PARTY_TAX_PROFILE_ID = RT.CONTENT_OWNER_ID))) AND RT.RATE_TYPE_CODE <> 'RECOVERY' AND (RT.TAX_CLASS IS NULL OR RT.TAX_CLASS = 'INPUT') AND TL.TAX_RATE_ID = RT.TAX_RATE_ID AND TL.LANGUAGE = USERENV('LANG') AND RG.TAX_REGIME_CODE = RT.TAX_REGIME_CODE AND RG.TAX_REGIME_ID = RTL.TAX_REGIME_ID AND RTL.LANGUAGE = USERENV('LANG') AND TX.TAX_REGIME_CODE = RT.TAX_REGIME_CODE AND TX.TAX = RT.TAX AND TX.OFFSET_TAX_FLAG <> 'Y' AND TX.TAX_ID = TTL.TAX_ID AND TTL.LANGUAGE = USERENV('LANG') AND ST.TAX_REGIME_CODE = RT.TAX_REGIME_CODE AND ST.TAX = RT.TAX AND ST.TAX_STATUS_CODE = RT.TAX_STATUS_CODE AND ST.ALLOW_RATE_OVERRIDE_FLAG = 'Y' AND ST.TAX_STATUS_ID = STL.TAX_STATUS_ID AND STL.LANGUAGE = USERENV('LANG') AND RT.TAX_JURISDICTION_CODE IS NULL UNION SELECT RT.TAX_REGIME_CODE TAX_REGIME_CODE
, RTL.TAX_REGIME_NAME TAX_REGIME_NAME
, RT.TAX TAX
, TTL.TAX_FULL_NAME TAX_FULL_NAME
, RT.TAX_STATUS_CODE TAX_STATUS_CODE
, STL.TAX_STATUS_NAME TAX_STATUS_NAME
, RT.TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE
, JTL.TAX_JURISDICTION_NAME TAX_JURISDICTION_NAME
, RT.TAX_RATE_CODE TAX_RATE_CODE
, NVL(TL.TAX_RATE_NAME
, RT.TAX_RATE_CODE) TAX_RATE_NAME
, DECODE(RT.RATE_TYPE_CODE
, 'QUANTITY'
, RT.QUANTITY_RATE
, 'PERCENTAGE'
, RT.PERCENTAGE_RATE
, 0) TAX_RATE
, RT.ACTIVE_FLAG ACTIVE_FLAG
, RT.EFFECTIVE_FROM EFFECTIVE_FROM
, RT.EFFECTIVE_TO EFFECTIVE_TO FROM ZX_SCO_RATES RT
, ZX_RATES_TL TL
, ZX_REGIMES_B_V RG
, ZX_REGIMES_TL RTL
, ZX_SCO_TAXES TX
, ZX_TAXES_TL TTL
, ZX_SCO_STATUS ST
, ZX_STATUS_TL STL
, ZX_JURISDICTIONS_B JR
, ZX_JURISDICTIONS_TL JTL WHERE RT.TAX_RATE_CODE IN (SELECT LOOKUP_CODE
FROM ZX_INPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = RT.TAX_RATE_CODE AND ORG_ID IN(-99
, (SELECT PARTY_ID
FROM ZX_PARTY_TAX_PROFILE WHERE PARTY_TAX_PROFILE_ID = RT.CONTENT_OWNER_ID))) AND RT.RATE_TYPE_CODE <> 'RECOVERY' AND (RT.TAX_CLASS IS NULL OR RT.TAX_CLASS = 'INPUT') AND TL.TAX_RATE_ID = RT.TAX_RATE_ID AND TL.LANGUAGE = USERENV('LANG') AND RG.TAX_REGIME_CODE = RT.TAX_REGIME_CODE AND RG.TAX_REGIME_ID = RTL.TAX_REGIME_ID AND RTL.LANGUAGE = USERENV('LANG') AND TX.TAX_REGIME_CODE = RT.TAX_REGIME_CODE AND TX.TAX = RT.TAX AND TX.OFFSET_TAX_FLAG <> 'Y' AND TX.TAX_ID = TTL.TAX_ID AND TTL.LANGUAGE = USERENV('LANG') AND ST.TAX_REGIME_CODE = RT.TAX_REGIME_CODE AND ST.TAX = RT.TAX AND ST.TAX_STATUS_CODE = RT.TAX_STATUS_CODE AND ST.ALLOW_RATE_OVERRIDE_FLAG = 'Y' AND ST.TAX_STATUS_ID = STL.TAX_STATUS_ID AND STL.LANGUAGE = USERENV('LANG') AND RT.TAX_JURISDICTION_CODE IS NOT NULL AND JR.TAX_REGIME_CODE = RT.TAX_REGIME_CODE AND JR.TAX = RT.TAX AND JR.TAX_JURISDICTION_CODE = RT.TAX_JURISDICTION_CODE AND JR.TAX_JURISDICTION_ID = JTL.TAX_JURISDICTION_ID AND JTL.LANGUAGE = USERENV('LANG')