View: OKL_MLS_EXTRACT_LINE_VL

Product:	OKL - Lease and Finance Management
Description:	Line MLS extract object
Implementation/DBA Data:	APPS.OKL_MLS_EXTRACT_LINE_VL

View Text

SELECT DIST.ACCOUNTING_EVENT_ID EVENT_ID
, DIST.ID LINE_NUMBER
, TELL.LANGUAGE LANGUAGE
, TELL.INVENTORY_ITEM_NAME TELL_INVENTORY_ITEM_NAME
, TELL.INVENTORY_ORG_NAME TELL_INVENTORY_ORG_NAME
, STM_TL.NAME STM_STREAM_TYPE_NAME
FROM OKL_TXL_CNTRCT_LNS_ALL TCL
, OKL_TRNS_ACC_DSTRS_ALL DIST
, OKL_TXL_EXTENSION_B TEL
, OKL_TXL_EXTENSION_TL TELL
, OKL_STRM_TYPE_TL STM_TL
WHERE TCL.ID = DIST.SOURCE_ID
AND DIST.SOURCE_TABLE = 'OKL_TXL_CNTRCT_LNS'
AND TCL.ID = TEL.SOURCE_ID(+)
AND TEL.SOURCE_TABLE(+) = 'OKL_TXL_CNTRCT_LNS'
AND TEL.LINE_EXTENSION_ID = TELL.LINE_EXTENSION_ID(+)
AND TCL.STY_ID = STM_TL.ID
AND TELL.LANGUAGE = STM_TL.LANGUAGE

Columns