MSC_METADATA_OBJECTS_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
OBJECT_ID OBJECT_NAME OBJECT_DESCRIPTION OBJECT_TYPE OBJECT_PLAN_TYPE OBJECT_DEFINITION OBJECT_ACCESS DEFAULT_FLAG OBJECT_OWNER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT b.OBJECT_ID, tl.OBJECT_NAME, tl.OBJECT_DESCRIPTION, b.OBJECT_TYPE, b.OBJECT_PLAN_TYPE, b.OBJECT_DEFINITION, b.OBJECT_ACCESS, b.DEFAULT_FLAG, b.OBJECT_OWNER, b.CREATED_BY, b.CREATION_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN, b.LAST_UPDATE_DATE, b.OBJECT_VERSION_NUMBER FROM MSC_METADATA_OBJECTS_B b, MSC_METADATA_OBJECTS_TL tl WHERE b.OBJECT_ID=tl.OBJECT_ID AND tl.LANGUAGE = USERENV('LANG')