VIEW: APPS.CE_MISC_TAX_CODE_V

Source

View Text - Preformatted

SELECT sco.tax_rate_code TAX_CODE, sco.tax, abs(decode(sco.rate_type_code,'QUANTITY',sco.quantity_rate,sco.percentage_rate )) Tax_Rate, sco.tax_Rate_id , sco.EFFECTIVE_FROM , sco.EFFECTIVE_TO , accounts.LEDGER_ID , substr(sco.tax_class,1,1) , accounts.INTERNAL_ORGANIZATION_ID ORG_ID FROM zx_sco_rates sco, zx_accounts accounts WHERE sco.active_flag='Y' and accounts.tax_account_entity_id = sco.tax_rate_id and accounts.tax_account_entity_code = 'RATES' and sco.tax_jurisdiction_code is NULL and sco.tax <> 'LOCATION' order by sco.tax_rate_code

View Text - HTML Formatted

SELECT SCO.TAX_RATE_CODE TAX_CODE
, SCO.TAX
, ABS(DECODE(SCO.RATE_TYPE_CODE
, 'QUANTITY'
, SCO.QUANTITY_RATE
, SCO.PERCENTAGE_RATE )) TAX_RATE
, SCO.TAX_RATE_ID
, SCO.EFFECTIVE_FROM
, SCO.EFFECTIVE_TO
, ACCOUNTS.LEDGER_ID
, SUBSTR(SCO.TAX_CLASS
, 1
, 1)
, ACCOUNTS.INTERNAL_ORGANIZATION_ID ORG_ID
FROM ZX_SCO_RATES SCO
, ZX_ACCOUNTS ACCOUNTS
WHERE SCO.ACTIVE_FLAG='Y'
AND ACCOUNTS.TAX_ACCOUNT_ENTITY_ID = SCO.TAX_RATE_ID
AND ACCOUNTS.TAX_ACCOUNT_ENTITY_CODE = 'RATES'
AND SCO.TAX_JURISDICTION_CODE IS NULL
AND SCO.TAX <> 'LOCATION' ORDER BY SCO.TAX_RATE_CODE