VIEW: APPS.OKE_WORKFLOWS_V

Source

View Text - Preformatted

SELECT B.ROWID ,B.SOURCE_CODE ,B.USAGE_CODE ,B.CREATED_BY ,B.CREATION_DATE ,B.LAST_UPDATED_BY ,B.LAST_UPDATE_DATE ,B.LAST_UPDATE_LOGIN ,W.DISPLAY_NAME ,B.WF_ITEM_TYPE ,P.DISPLAY_NAME ,B.WF_PROCESS FROM OKE_WORKFLOWS B ,WF_ITEM_TYPES_VL W ,WF_RUNNABLE_PROCESSES_V P WHERE W.NAME (+)=B.WF_ITEM_TYPE AND P.ITEM_TYPE (+)=B.WF_ITEM_TYPE AND P.PROCESS_NAME (+)=B.WF_PROCESS

View Text - HTML Formatted

SELECT B.ROWID
, B.SOURCE_CODE
, B.USAGE_CODE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, W.DISPLAY_NAME
, B.WF_ITEM_TYPE
, P.DISPLAY_NAME
, B.WF_PROCESS
FROM OKE_WORKFLOWS B
, WF_ITEM_TYPES_VL W
, WF_RUNNABLE_PROCESSES_V P
WHERE W.NAME (+)=B.WF_ITEM_TYPE
AND P.ITEM_TYPE (+)=B.WF_ITEM_TYPE
AND P.PROCESS_NAME (+)=B.WF_PROCESS