1. Tables and Views for SCM
  2. MSC_SOP_MEASURE_COPYSET_VL

MSC_SOP_MEASURE_COPYSET_VL

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

MEASURE_COPYSET_ID

MEASURE_COPYSET_NAME

DESCRIPTION

WORK_AREA_TYPE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT

B.MEASURE_COPYSET_ID,

T.MEASURE_COPYSET_NAME,

T.DESCRIPTION,

B.WORK_AREA_TYPE,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER

FROM

MSC_SOP_MEASURE_COPYSET_B B,

MSC_SOP_MEASURE_COPYSET_TL T

WHERE B.MEASURE_COPYSET_ID = T.MEASURE_COPYSET_ID

AND T.language = USERENV('LANG')