View: CE_MISC_TAX_CODE_V

Product:	CE - Cash Management
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CE_MISC_TAX_CODE_V

View Text

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

Columns