MSC_EQUIPMENT_GROUPS_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
EQUIPMENT_GROUP_ID GROUP_CODE GROUP_NAME EFFECTIVE_WEIGHT EFFECTIVE_WEIGHT_UOM EFFECTIVE_VOLUME EFFECTIVE_VOLUME_UOM CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT groupsB.EQUIPMENT_GROUP_ID EQUIPMENT_GROUP_ID, groupsB.GROUP_CODE GROUP_CODE, groupsTL.GROUP_NAME GROUP_NAME, groupsB.EFFECTIVE_WEIGHT EFFECTIVE_WEIGHT, groupsB.EFFECTIVE_WEIGHT_UOM EFFECTIVE_WEIGHT_UOM, groupsB.EFFECTIVE_VOLUME EFFECTIVE_VOLUME, groupsB.EFFECTIVE_VOLUME_UOM EFFECTIVE_VOLUME_UOM, groupsB.CREATION_DATE CREATION_DATE, groupsB.CREATED_BY CREATED_BY, groupsB.LAST_UPDATE_DATE LAST_UPDATE_DATE, groupsB.LAST_UPDATED_BY LAST_UPDATED_BY, groupsB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, groupsB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM MSC_EQUIPMENT_GROUPS_B groupsB, MSC_EQUIPMENT_GROUPS_TL groupsTL WHERE groupsTL.LANGUAGE = USERENV('LANG') AND groupsB.EQUIPMENT_GROUP_ID = groupsTL.EQUIPMENT_GROUP_ID