MSC_EQUIPMENT_PROFILES_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
EQUIPMENT_PROFILE_ID PROFILE_CODE PROFILE_NAME CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT profilesB.EQUIPMENT_PROFILE_ID EQUIPMENT_PROFILE_ID, profilesB.PROFILE_CODE PROFILE_CODE, profilesTL.PROFILE_NAME PROFILE_NAME, profilesB.CREATION_DATE CREATION_DATE, profilesB.CREATED_BY CREATED_BY, profilesB.LAST_UPDATE_DATE LAST_UPDATE_DATE, profilesB.LAST_UPDATED_BY LAST_UPDATED_BY, profilesB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, profilesB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM MSC_EQUIPMENT_PROFILES_B profilesB, MSC_EQUIPMENT_PROFILES_TL profilesTL WHERE profilesTL.LANGUAGE = USERENV('LANG') AND profilesB.EQUIPMENT_PROFILE_ID = profilesTL.EQUIPMENT_PROFILE_ID