VIEW: APPS.WF_ACTIVITIES_VL

Source

View Text - Preformatted

SELECT /* $Header: afwf.odf 120.31.12020000.3 2013/03/25 20:35:25 vshanmug ship $ */ B.ROWID ROW_ID, B.ITEM_TYPE, B.NAME, B.VERSION, B.TYPE, B.RERUN, B.EXPAND_ROLE, B.PROTECT_LEVEL, B.CUSTOM_LEVEL, B.BEGIN_DATE, B.END_DATE, B.FUNCTION, B.RESULT_TYPE, B.COST, B.READ_ROLE, B.WRITE_ROLE, B.EXECUTE_ROLE, B.ICON_NAME, B.MESSAGE, B.ERROR_PROCESS, B.RUNNABLE_FLAG, B.ERROR_ITEM_TYPE, B.FUNCTION_TYPE, B.EVENT_NAME, B.DIRECTION, T.DISPLAY_NAME, T.DESCRIPTION from WF_ACTIVITIES B, WF_ACTIVITIES_TL T WHERE B.ITEM_TYPE = T.ITEM_TYPE and B.NAME = T.NAME and B.VERSION = T.VERSION and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT /* $HEADER: AFWF.ODF 120.31.12020000.3 2013/03/25 20:35:25 VSHANMUG SHIP $ */ B.ROWID ROW_ID
, B.ITEM_TYPE
, B.NAME
, B.VERSION
, B.TYPE
, B.RERUN
, B.EXPAND_ROLE
, B.PROTECT_LEVEL
, B.CUSTOM_LEVEL
, B.BEGIN_DATE
, B.END_DATE
, B.FUNCTION
, B.RESULT_TYPE
, B.COST
, B.READ_ROLE
, B.WRITE_ROLE
, B.EXECUTE_ROLE
, B.ICON_NAME
, B.MESSAGE
, B.ERROR_PROCESS
, B.RUNNABLE_FLAG
, B.ERROR_ITEM_TYPE
, B.FUNCTION_TYPE
, B.EVENT_NAME
, B.DIRECTION
, T.DISPLAY_NAME
, T.DESCRIPTION
FROM WF_ACTIVITIES B
, WF_ACTIVITIES_TL T
WHERE B.ITEM_TYPE = T.ITEM_TYPE
AND B.NAME = T.NAME
AND B.VERSION = T.VERSION
AND T.LANGUAGE = USERENV('LANG')