MSC_GROUPS_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
GROUP_ID CATALOG_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN GROUP_NAME DESCRIPTION GROUP_CODE

Query

SQL_Statement

SELECT MSC_GROUPS_B.GROUP_ID GROUP_ID, MSC_GROUPS_B.CATALOG_ID CATALOG_ID, MSC_GROUPS_B.CREATED_BY CREATED_BY, MSC_GROUPS_B.CREATION_DATE CREATION_DATE, MSC_GROUPS_B.LAST_UPDATED_BY LAST_UPDATED_BY, MSC_GROUPS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, MSC_GROUPS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MSC_GROUPS_TL.GROUP_NAME GROUP_NAME, MSC_GROUPS_TL.DESCRIPTION DESCRIPTION, MSC_GROUPS_B.GROUP_CODE GROUP_CODE FROM MSC_GROUPS_B, MSC_GROUPS_TL WHERE MSC_GROUPS_B.GROUP_ID = MSC_GROUPS_TL.GROUP_ID AND MSC_GROUPS_TL.LANGUAGE = USERENV('LANG')