MSC_AGGR_TABLE_DEFINITIONS_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
DEFINITION_ID CARD_SEQ_NUM CARD_ORIENTATION HIERARCHY_ID LEVEL_ID M1_ID M2_ID M3_ID M4_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER NAME DESCRIPTION

Query

SQL_Statement

SELECT b.DEFINITION_ID DEFINITION_ID, b.CARD_SEQ_NUM CARD_SEQ_NUM, b.CARD_ORIENTATION CARD_ORIENTATION, b.HIERARCHY_ID HIERARCHY_ID, b.LEVEL_ID LEVEL_ID, b.M1_ID M1_ID, b.M2_ID M2_ID, b.M3_ID M3_ID, b.M4_ID M4_ID, b.CREATED_BY CREATED_BY, b.CREATION_DATE CREATION_DATE, b.LAST_UPDATED_BY LAST_UPDATED_BY, b.LAST_UPDATE_DATE LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, b.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, tl.NAME NAME, tl.DESCRIPTION DESCRIPTION FROM MSC_AGGR_TABLE_DEFINITIONS_B b, MSC_AGGR_TABLE_DEFINITIONS_TL tl WHERE b.DEFINITION_ID = tl.DEFINITION_ID and tl.language = userenv('LANG')