PSC_CE_WF_PRCS_GRP_VL

Details

• Schema: FUSION

• Object owner: PSC_CE

• Object type: VIEW

Columns

Name

PROCESS_GRP_ID AGENCY_ID ENABLED_FLAG DESCRIPTION CS_SPACE_NAME CS_SPACE_ID CS_PROJECT_ID CS_PROCESS_VERSION CS_PROCESS_DEF_ID CS_PROCESS_DEF_KEY CS_PRCS_CATEGORY CS_GLOBAL_TASK_ID CS_GLOBAL_TASK_NAME INC_SPACE_NAME INC_SPACE_ID INC_PROJECT_ID INC_PROCESS_VERSION INC_PROCESS_DEF_ID INC_PROCESS_DEF_KEY INC_PRCS_CATEGORY INC_GLOBAL_TASK_ID INC_GLOBAL_TASK_NAME OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CASE_ST_FLAG ADHOC_NOTICE_ST_FLAG SYSTEM_NOTICE_ST_FLAG

Query

SQL_Statement

SELECT B.PROCESS_GRP_ID, B.AGENCY_ID, B.ENABLED_FLAG, TL.DESCRIPTION, B.CS_SPACE_NAME, B.CS_SPACE_ID, B.CS_PROJECT_ID, B.CS_PROCESS_VERSION, B.CS_PROCESS_DEF_ID, B.CS_PROCESS_DEF_KEY, B.CS_PRCS_CATEGORY, B.CS_GLOBAL_TASK_ID, B.CS_GLOBAL_TASK_NAME, B.INC_SPACE_NAME, B.INC_SPACE_ID, B.INC_PROJECT_ID, B.INC_PROCESS_VERSION, B.INC_PROCESS_DEF_ID, B.INC_PROCESS_DEF_KEY, B.INC_PRCS_CATEGORY, B.INC_GLOBAL_TASK_ID, B.INC_GLOBAL_TASK_NAME, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.CASE_ST_FLAG, B.ADHOC_NOTICE_ST_FLAG, B.SYSTEM_NOTICE_ST_FLAG FROM PSC_CE_WF_PRCS_GRP_B B, PSC_CE_WF_PRCS_GRP_TL TL WHERE B.PROCESS_GRP_ID = TL.PROCESS_GRP_ID AND B.AGENCY_ID = TL.AGENCY_ID AND TL.LANGUAGE = USERENV('LANG')