VIEW: APPS.ZX_AP_TAX_JRNL_LINE_DESC_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)