ZX_AP_TAX_JRNL_LINE_DESC_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name
REC_NREC_TAX_DIST_ID TAX_REGIME_NAME TAX_FULL_NAME TAX_STATUS_NAME TAX_RATE_NAME TAX_JURISDICTION_CODE RECOVERY_RATE_NAME RECOVERY_TYPE_CODE

Query

SQL_Statement

SELECT tax_dist.REC_NREC_TAX_DIST_ID REC_NREC_TAX_DIST_ID, regimes_tl.TAX_REGIME_NAME TAX_REGIME_NAME, taxes_tl.TAX_FULL_NAME TAX_FULL_NAME, status_tl.TAX_STATUS_NAME TAX_STATUS_NAME , rates_tl.TAX_RATE_NAME TAX_RATE_NAME, jur.TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE, rec_rates_tl.TAX_RATE_NAME RECOVERY_RATE_NAME, tax_dist.RECOVERY_TYPE_CODE RECOVERY_TYPE_CODE FROM zx_rec_nrec_dist tax_dist, zx_rates_tl rec_rates_tl, 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 tax_dist.recovery_rate_id = rec_rates_tl.tax_rate_id (+) AND tax_dist.tax_regime_id = regimes_tl.tax_regime_id AND tax_dist.tax_id = taxes_tl.tax_id AND tax_dist.tax_status_id = status_tl.tax_status_id AND tax_dist.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 nvl(rec_rates_tl.language,userenv('LANG')) = userenv('LANG') AND regimes_tl.LANGUAGE = userenv('LANG') AND tax_dist.TAX_JURISDICTION_ID = jur.TAX_JURISDICTION_ID(+)