MSC_SEGMENT_GROUP_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
SEGMENT_GROUP_ID GROUP_NAME DESCRIPTION SIMULATION_SET_ID SUB_INV_FLAG SOURCE_SYSTEM_ID CATALOG_ID KEEP_OVERRIDES STATUS LAST_RUN_DATE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER HIERARCHY_ID

Query

SQL_Statement

SELECT MSC_SEGMENT_GROUP_B.SEGMENT_GROUP_ID SEGMENT_GROUP_ID, MSC_SEGMENT_GROUP_TL.GROUP_NAME GROUP_NAME, MSC_SEGMENT_GROUP_TL.DESCRIPTION DESCRIPTION, MSC_SEGMENT_GROUP_B.SIMULATION_SET_ID SIMULATION_SET_ID, MSC_SEGMENT_GROUP_B.SUB_INV_FLAG SUB_INV_FLAG, MSC_SEGMENT_GROUP_B.SOURCE_SYSTEM_ID SOURCE_SYSTEM_ID, MSC_SEGMENT_GROUP_B.CATALOG_ID CATALOG_ID, MSC_SEGMENT_GROUP_B.KEEP_OVERRIDES KEEP_OVERRIDES, MSC_SEGMENT_GROUP_B.STATUS STATUS, MSC_SEGMENT_GROUP_B.LAST_RUN_DATE LAST_RUN_DATE, MSC_SEGMENT_GROUP_B.CREATED_BY CREATED_BY, MSC_SEGMENT_GROUP_B.CREATION_DATE CREATION_DATE, MSC_SEGMENT_GROUP_B.LAST_UPDATED_BY LAST_UPDATED_BY, MSC_SEGMENT_GROUP_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, MSC_SEGMENT_GROUP_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MSC_SEGMENT_GROUP_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, MSC_SEGMENT_GROUP_B.HIERARCHY_ID HIERARCHY_ID FROM MSC_SEGMENT_GROUP_TL, MSC_SEGMENT_GROUP_B WHERE MSC_SEGMENT_GROUP_B.SEGMENT_GROUP_ID = MSC_SEGMENT_GROUP_TL.SEGMENT_GROUP_ID AND MSC_SEGMENT_GROUP_TL.LANGUAGE = USERENV('LANG')