VIEW: APPS.OKL_MLS_EXTRACT_HDR_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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