1. Tables and Views for Financials
  2. ZX_JRNL_LINE_DESC_V

ZX_JRNL_LINE_DESC_V

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: VIEW

Columns

Name

TAX_LINE_ID

TAX_REGIME_NAME

TAX_FULL_NAME

TAX_STATUS_NAME

TAX_RATE_NAME

TAX_JURISDICTION_CODE

LANGUAGE

Query

SQL_Statement

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