VIEW: APPS.ZX_JRNL_LINE_DESC_V

Source

View Text - Preformatted

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
   

View Text - HTML Formatted

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