ZX_WHT_LINE_DESC_V

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: VIEW

Columns

Name
AWT_TAX_LINE_ID AWT_TRX_ID AWT_TRX_LINE_ID AWT_TRX_LEVEL_TYPE AWT_TAX_REGIME_NAME AWT_TAX_FULL_NAME AWT_TAX_STATUS_NAME AWT_TAX_RATE_NAME AWT_TAX_JURISDICTION_CODE

Query

SQL_Statement

SELECT wht.tax_line_id AWT_TAX_LINE_ID, wht.trx_id AWT_TRX_ID, wht.trx_line_id AWT_TRX_LINE_ID, wht.trx_level_type AWT_TRX_LEVEL_TYPE, regimes_tl.TAX_REGIME_NAME AWT_TAX_REGIME_NAME, taxes_tl.TAX_FULL_NAME AWT_TAX_FULL_NAME, status_tl.TAX_STATUS_NAME AWT_TAX_STATUS_NAME, rates_tl.TAX_RATE_NAME AWT_TAX_RATE_NAME, jur.TAX_JURISDICTION_CODE AWT_TAX_JURISDICTION_CODE FROM zx_withholding_lines wht, zx_regimes_tl regimes_tl, zx_taxes_tl taxes_tl, zx_status_tl status_tl, zx_rates_tl rates_tl, zx_jurisdictions_b jur WHERE wht.tax_regime_id = regimes_tl.tax_regime_id AND wht.tax_id = taxes_tl.tax_id AND wht.tax_status_id = status_tl.tax_status_id AND wht.tax_rate_id = rates_tl.tax_rate_id AND regimes_tl.language = taxes_tl.language AND regimes_tl.language = status_tl.language AND regimes_tl.language = rates_tl.language AND regimes_tl.LANGUAGE = userenv('LANG') AND nvl(wht.TAX_JURISDICTION_ID,-99) = jur.TAX_JURISDICTION_ID(+)