VIEW: APPS.GL_TAX_CODES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'