MSC_SOP_PLAN_CYCLE_TASK_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
TASK_ID STATUS ASSIGNED_DATE DUE_DATE COMPLETION_DATE ASSIGNED_TO OWNER PLAN_CYCLE_ID SUB_PROCESS_ID DISPLAY_ORDER TASK_TYPE OFF_SET_DAYS ACTIVITY_ID LINK_TO OBJECT_VERSION_NUMBER LAST_UPDATED_BY LAST_UPDATE_DATE CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN TASK_TITLE COMMENTS LINKTYPE LINKID TASKFLOW_CODE LAYOUT_ID

Query

SQL_Statement

SELECT B.TASK_ID, B.STATUS , B.ASSIGNED_DATE, B.DUE_DATE, B.COMPLETION_DATE, B.ASSIGNED_TO, B.OWNER , B.PLAN_CYCLE_ID, B.SUB_PROCESS_ID, B.DISPLAY_ORDER , B.TASK_TYPE , B.OFF_SET_DAYS , B.ACTIVITY_ID , B.LINK_TO , B.OBJECT_VERSION_NUMBER , B.LAST_UPDATED_BY , B.LAST_UPDATE_DATE , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_LOGIN , T.TASK_TITLE, B.COMMENTS , B.LINKTYPE, B.LINKID, B.TASKFLOW_CODE, B.LAYOUT_ID FROM MSC_SOP_PLAN_CYCLE_TASK_B B, MSC_SOP_PLAN_CYCLE_TASK_TL T WHERE B.TASK_ID = T.TASK_ID AND T.language = USERENV('LANG')