VIEW: APPS.OKE_CHG_LOGS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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