View: GL_TAX_CODES_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_TAX_CODES_V

View Text

SELECT ACCTS.INTERNAL_ORGANIZATION_ID ORG_ID
, ACCTS.LEDGER_ID LEDGER_ID
, DECODE (RATES.TAX_CLASS
, NULL
, 'T'
, 'OUTPUT'
, 'O'
, 'INPUT'
, 'I') TAX_TYPE_CODE
, LK.MEANING TAX_TYPE
, NVL(RATES.SOURCE_ID
, RATES.TAX_RATE_ID) TAX_CODE_ID
, RATES.PERCENTAGE_RATE TAX_RATE
, ACCTS.TAX_ACCOUNT_CCID TAX_CODE_COMBINATION_ID
, RATES.TAX_RATE_NAME DESCRIPTION
, RATES.EFFECTIVE_FROM START_DATE
, RATES.EFFECTIVE_TO END_DATE
, NVL(RATES.ACTIVE_FLAG
, 'Y') VALID_FLAG
, NVL(RATES.ACTIVE_FLAG
, 'Y') ENABLED_FLAG
, RATES.TAX_CLASS TAX_CLASS
, 'Y' DISPLAYED_FLAG
, RATES.TAX_REGIME_CODE TAX_REGIME_CODE
, RATES.TAX TAX
, RATES.TAX_STATUS_CODE TAX_STATUS_CODE
, RATES.TAX_RATE_CODE TAX_CODE
FROM ZX_RATES_VL RATES
, ZX_ACCOUNTS ACCTS
, GL_LOOKUPS LK
, ZX_TAXES_B TAXES
WHERE LK.LOOKUP_CODE = DECODE (RATES.TAX_CLASS
, NULL
, 'T'
, 'OUTPUT'
, 'O'
, 'INPUT'
, 'I')
AND LK.LOOKUP_TYPE = 'TAX_TYPE'
AND (RATES.TAX_CLASS IS NULL OR (RATES.TAX_STATUS_CODE <> 'STD_AR_INPUT'
AND RATES.TAX_CLASS IS NOT NULL))
AND RATES.RATE_TYPE_CODE = 'PERCENTAGE'
AND ACCTS.TAX_ACCOUNT_ENTITY_ID(+)= RATES.TAX_RATE_ID
AND ACCTS.TAX_ACCOUNT_ENTITY_CODE(+)= 'RATES'
AND TAXES.TAX_REGIME_CODE = RATES.TAX_REGIME_CODE
AND TAXES.TAX = RATES.TAX
AND TAXES.SOURCE_TAX_FLAG ='Y'
AND NVL(TAXES.OFFSET_TAX_FLAG
, 'N') <> 'Y'
AND RATES.TAX_JURISDICTION_CODE IS NULL

Columns