MSC_WORKAREA_TASK_FLOWS_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
TASK_FLOW_ID TASK_FLOW_URI TASK_FLOW_CODE TASK_FLOW_TYPE TASK_FLOW_NAME DESCRIPTION SP_FLAG DP_FLAG CP_FLAG GOP_FLAG SNOP_FLAG SIM_FLAG ODS_FLAG VCM_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY CREATED_BY CREATION_DATE OBJECT_VERSION_NUMBER LAST_UPDATE_LOGIN NAV_MODE_ONLY REPL_FLAG BM_FLAG

Query

SQL_Statement

SELECT B.TASK_FLOW_ID,B.TASK_FLOW_URI,b.TASK_FLOW_CODE,B.TASK_FLOW_TYPE, T.TASK_FLOW_NAME, T.DESCRIPTION, B.SP_FLAG,B.DP_FLAG, B.CP_FLAG,B.GOP_FLAG, B.SNOP_FLAG,B.SIM_FLAG, B.ODS_FLAG,B.VCM_FLAG, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATED_BY, B.CREATION_DATE, B.OBJECT_VERSION_NUMBER, B.LAST_UPDATE_LOGIN, B.NAV_MODE_ONLY, B.REPL_FLAG, B.BM_FLAG FROM MSC_WORKAREA_TASK_FLOWS_B B, MSC_WORKAREA_TASK_FLOWS_TL T WHERE T.TASK_FLOW_ID=B.TASK_FLOW_ID AND T.LANGUAGE= USERENV('LANG')