eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ZX_SCO_INPUT_RATES_V

Source

View Text - Preformatted


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')

View Text - HTML Formatted

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')