MSC_EQUIP_MULTISRC_GROUPS_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
MULTISOURCE_PICKUP_GROUP_ID MULTISOURCE_PICKUP_GROUP_CODE MULTISOURCE_PICKUP_GROUP_NAME CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT groupsB.MULTISOURCE_PICKUP_GROUP_ID MULTISOURCE_PICKUP_GROUP_ID, groupsB.MULTISOURCE_PICKUP_GROUP_CODE MULTISOURCE_PICKUP_GROUP_CODE, groupsTL.MULTISOURCE_PICKUP_GROUP_NAME MULTISOURCE_PICKUP_GROUP_NAME, 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_EQUIP_MULTISRC_GROUPS_B groupsB, MSC_EQUIP_MULTISRC_GROUPS_TL groupsTL WHERE groupsTL.LANGUAGE = USERENV('LANG') AND groupsB.MULTISOURCE_PICKUP_GROUP_ID = groupsTL.MULTISOURCE_PICKUP_GROUP_ID