View: OKL_MLS_EXTRACT_HDR_VL

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

View Text

SELECT XE.EVENT_ID EVENT_ID
, TEHL.LANGUAGE LANGUAGE
, TEHL.CONTRACT_STATUS TEHL_CONTRACT_STATUS
, TEHL.INV_AGRMNT_STATUS TEHL_INV_AGRMNT_STATUS
, TEHL.TRANSACTION_TYPE_NAME TEHL_TRANSACTION_TYPE_NAME
, TEHL.CHR_OPERATING_UNIT_NAME TEHL_CHR_OPERATING_UNIT_NAME
FROM OKL_TRX_CONTRACTS_ALL TCN
, OKL_TRX_EXTENSION_B TEH
, OKL_TRX_EXTENSION_TL TEHL
, XLA_EVENTS_GT XE
WHERE TCN.ID = TEH.SOURCE_ID (+)
AND TEH.SOURCE_TABLE(+) = 'OKL_TRX_CONTRACTS'
AND TEH.HEADER_EXTENSION_ID = TEHL.HEADER_EXTENSION_ID(+)
AND XE.APPLICATION_ID = 540
AND XE.SOURCE_ID_INT_1 = TCN.ID

Columns