MSC_SOP_PLAN_SUB_PROCESS_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
SUB_PROCESS_ID OBJECT_VERSION_NUMBER LAST_UPDATED_BY LAST_UPDATE_DATE CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN SUB_PROCESS_NAME

Query

SQL_Statement
SELECT B.SUB_PROCESS_ID, B.OBJECT_VERSION_NUMBER , B.LAST_UPDATED_BY , B.LAST_UPDATE_DATE , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_LOGIN , T.SUB_PROCESS_NAME FROM MSC_SOP_PLAN_SUB_PROCESS_B B, MSC_SOP_PLAN_SUB_PROCESS_TL T WHERE B.SUB_PROCESS_ID = T.SUB_PROCESS_ID AND T.language = USERENV('LANG')