MSC_SOP_PLAN_ACTIVITY_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ACTIVITY_ID OWNER ACTIVITY_TYPE CATEGORY LINK_TO DISPLAY_ORDER DUE_DATE COMPLETION_DATE ASSIGNED_TO OBJECT_VERSION_NUMBER LAST_UPDATED_BY LAST_UPDATE_DATE CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ACTIVITY_NAME ACTIVITY_DESC PLAN_CYCLE_ID SUB_PROCESS_ID STATUS LINKTYPE LINKID TASKFLOW_CODE LAYOUT_ID

Query

SQL_Statement

SELECT B.ACTIVITY_ID, B.OWNER, B.ACTIVITY_TYPE, B.CATEGORY , B.LINK_TO , B.DISPLAY_ORDER, B.DUE_DATE , B.COMPLETION_DATE , B.ASSIGNED_TO , B.OBJECT_VERSION_NUMBER , B.LAST_UPDATED_BY , B.LAST_UPDATE_DATE , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_LOGIN , T.ACTIVITY_NAME, T.ACTIVITY_DESC, B.PLAN_CYCLE_ID, B.SUB_PROCESS_ID, B.STATUS, B.LINKTYPE, B.LINKID, B.TASKFLOW_CODE, B.LAYOUT_ID FROM MSC_SOP_PLAN_ACTIVITY_B B, MSC_SOP_PLAN_ACTIVITY_TL T WHERE B.ACTIVITY_ID = T.ACTIVITY_ID AND T.language = USERENV('LANG')