VIEW: APPS.OKL_ZX_EXTRACT_TAX_VL

Source

View Text - Preformatted

SELECT DIST.ACCOUNTING_EVENT_ID EVENT_ID ,DIST.ID LINE_NUMBER ,ZX.LANGUAGE LANGUAGE ,ZX.TAX_REGIME_NAME REF_TAX_REGIME_NAME ,ZX.TAX_FULL_NAME REF_TAX_FULL_NAME ,ZX.TAX_STATUS_NAME REF_TAX_STATUS_NAME ,ZX.TAX_RATE_NAME REF_TAX_RATE_NAME ,ZX.TAX_JURISDICTION_CODE REF_TAX_JURISDICTION_CODE FROM OKL_TXL_CNTRCT_LNS_ALL TCL ,OKL_TRNS_ACC_DSTRS_ALL DIST ,ZX_JRNL_LINE_DESC_V ZX WHERE TCL.TAX_LINE_ID = ZX.TAX_LINE_ID AND TCL.ID = DIST.SOURCE_ID AND DIST.SOURCE_TABLE = 'OKL_TXL_CNTRCT_LNS'

View Text - HTML Formatted

SELECT DIST.ACCOUNTING_EVENT_ID EVENT_ID
, DIST.ID LINE_NUMBER
, ZX.LANGUAGE LANGUAGE
, ZX.TAX_REGIME_NAME REF_TAX_REGIME_NAME
, ZX.TAX_FULL_NAME REF_TAX_FULL_NAME
, ZX.TAX_STATUS_NAME REF_TAX_STATUS_NAME
, ZX.TAX_RATE_NAME REF_TAX_RATE_NAME
, ZX.TAX_JURISDICTION_CODE REF_TAX_JURISDICTION_CODE
FROM OKL_TXL_CNTRCT_LNS_ALL TCL
, OKL_TRNS_ACC_DSTRS_ALL DIST
, ZX_JRNL_LINE_DESC_V ZX
WHERE TCL.TAX_LINE_ID = ZX.TAX_LINE_ID
AND TCL.ID = DIST.SOURCE_ID
AND DIST.SOURCE_TABLE = 'OKL_TXL_CNTRCT_LNS'