IRC_PROCESSES_VL

Details

• Schema: FUSION

• Object owner: IRC

• Object type: VIEW

Columns

Name
PROCESS_ID PROCESS_TEMPLATE_ID NAME DESCRIPTION CODE PHASE_ID STATUS_CODE TYPE_CODE GRAPH_TOPOLOGY USAGE_CODE IS_ACTIVE_FLAG TRACE_LOG MODULE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SETTING_ID IMPORT_CONTROL_FLAG SUPPRESS_CANDIDATE_NOTIF_FLAG SHOW_MOVE_FORWARD_FLAG SHOW_QUICK_REJECT_FLAG

Query

SQL_Statement

SELECT PROCESSB.PROCESS_ID PROCESS_ID, PROCESSB.PROCESS_TEMPLATE_ID, PROCESSTL.NAME NAME, PROCESSTL.DESCRIPTION DESCRIPTION, PROCESSB.CODE CODE, PROCESSB.PHASE_ID PHASE_ID, PROCESSB.STATUS_CODE STATUS_CODE, PROCESSB.TYPE_CODE TYPE_CODE, PROCESSB.GRAPH_TOPOLOGY GRAPH_TOPOLOGY, PROCESSB.USAGE_CODE USAGE_CODE, PROCESSB.IS_ACTIVE_FLAG IS_ACTIVE_FLAG, PROCESSB.TRACE_LOG TRACE_LOG, PROCESSB.MODULE_ID MODULE_ID, PROCESSB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PROCESSB.CREATED_BY CREATED_BY, PROCESSB.CREATION_DATE CREATION_DATE, PROCESSB.LAST_UPDATED_BY LAST_UPDATED_BY, PROCESSB.LAST_UPDATE_DATE LAST_UPDATE_DATE, PROCESSB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROCESSB.SETTING_ID, PROCESSB.IMPORT_CONTROL_FLAG, PROCESSB.SUPPRESS_CANDIDATE_NOTIF_FLAG, PROCESSB.SHOW_MOVE_FORWARD_FLAG, PROCESSB.SHOW_QUICK_REJECT_FLAG FROM IRC_PROCESSES_B PROCESSB, IRC_PROCESSES_TL PROCESSTL WHERE PROCESSB.PROCESS_ID = PROCESSTL.PROCESS_ID AND PROCESSTL.LANGUAGE = USERENV('LANG')