VRM_SOURCE_COLUMNS_VL

Details

• Schema: FUSION

• Object owner: VRM

• Object type: VIEW

Columns

Name
SOURCE_COLUMN_ID SOURCE_COLUMN_NAME DESCRIPTION OBJECT_LEVEL USED_IN_SEG_ASSIGN_FLAG USED_IN_MEA_RULE_FLAG IS_EXTENS_ATTR_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN MODULE_ID USED_IN_CONTRACT_RULE_FLAG USED_IN_OBLIG_RULE_FLAG

Query

SQL_Statement

SELECT B.SOURCE_COLUMN_ID, B.SOURCE_COLUMN_NAME, TL.DESCRIPTION, B.OBJECT_LEVEL, B.USED_IN_SEG_ASSIGN_FLAG, B.USED_IN_MEA_RULE_FLAG, B.IS_EXTENS_ATTR_FLAG, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.MODULE_ID, B.USED_IN_CONTRACT_RULE_FLAG, B.USED_IN_OBLIG_RULE_FLAG FROM VRM_SOURCE_COLUMNS_B B, VRM_SOURCE_COLUMNS_TL TL WHERE TL.SOURCE_COLUMN_ID = B.SOURCE_COLUMN_ID AND TL.LANGUAGE = USERENV('LANG')