[Home] [Help]
View: ZX_AP_TAX_JRNL_LINE_DESC_V
View Text
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(+)