[Home] [Help]
View: ZX_JRNL_LINE_DESC_V
View Text
SELECT
TAX_LINE.TAX_LINE_ID TAX_LINE_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
,
TAX_LINE.TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE
,
RATES_TL.LANGUAGE LANGUAGE
FROM
ZX_LINES TAX_LINE
,
ZX_RATES_TL RATES_TL
,
ZX_STATUS_TL STATUS_TL
,
ZX_TAXES_TL TAXES_TL
,
ZX_REGIMES_TL REGIMES_TL
WHERE
TAX_LINE.TAX_RATE_ID = RATES_TL.TAX_RATE_ID
AND TAX_LINE.TAX_ID = TAXES_TL.TAX_ID
AND TAX_LINE.TAX_STATUS_ID = STATUS_TL.TAX_STATUS_ID
AND TAX_LINE.TAX_REGIME_ID = REGIMES_TL.TAX_REGIME_ID
AND REGIMES_TL.LANGUAGE = TAXES_TL.LANGUAGE
AND REGIMES_TL.LANGUAGE = STATUS_TL.LANGUAGE
AND REGIMES_TL.LANGUAGE = RATES_TL.LANGUAGE