GL_TAX_CODES_V

Details

• Schema: FUSION

• Object owner: GL

• Object type: VIEW

Columns

Name
ORG_ID LEDGER_ID TAX_TYPE_CODE TAX_TYPE TAX_CODE_ID TAX_RATE TAX_CODE_COMBINATION_ID DESCRIPTION START_DATE END_DATE VALID_FLAG ENABLED_FLAG TAX_CLASS DISPLAYED_FLAG TAX_REGIME_CODE TAX TAX_STATUS_CODE TAX_CODE

Query

SQL_Statement

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