View: OKE_CHG_LOGS_V

Product:	OKE - Project Contracts
Description:	View for change request logs
Implementation/DBA Data:	APPS.OKE_CHG_LOGS_V

View Text

SELECT CL.ROWID
, CL.CHG_LOG_ID
, CL.CREATION_DATE
, CL.CREATED_BY
, CL.LAST_UPDATE_DATE
, CL.LAST_UPDATED_BY
, CL.LAST_UPDATE_LOGIN
, CL.CHG_REQUEST_ID
, CS.CHG_STATUS_NAME
, CL.CHG_STATUS_CODE
, WIT.DISPLAY_NAME
, CL.WF_ITEM_TYPE
, WA.DISPLAY_NAME
, CL.WF_ITEM_KEY
FROM OKE_CHG_LOGS CL
, OKE_CHG_STATUSES_TL CS
, WF_ITEM_TYPES_VL WIT
, WF_RUNNABLE_PROCESSES_V WA
WHERE CS.CHG_STATUS_CODE = CL.CHG_STATUS_CODE
AND CS.LANGUAGE = USERENV('LANG')
AND WIT.NAME (+) = CL.WF_ITEM_TYPE
AND WA.ITEM_TYPE (+) = CL.WF_ITEM_TYPE
AND WA.PROCESS_NAME (+) = CL.WF_PROCESS

Columns