View: OKL_ZX_EXTRACT_TAX_VL

Product:	OKL - Lease and Finance Management
Description:	Line extract object with tax details
Implementation/DBA Data:	APPS.OKL_ZX_EXTRACT_TAX_VL

View Text

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'

Columns