ACD_METRICS_MEAS_GRP_VL
Details
-
Schema: FUSION
-
Object owner: ACD
-
Object type: VIEW
Columns
Name |
---|
METRICS_MEASURES_GRP_ID SRC_TABLE_ID TARGET_TABLE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN NAME DESCRIPTION LANGUAGE SOURCE_LANG SRC_FQ_ENTITY_NAME SRC_FQ_VIEW_NAME TARGET_FQ_ENTITY_NAME TARGET_FQ_VIEW_NAME |
Query
SQL_Statement |
---|
SELECT B.METRICS_MEASURES_GRP_ID METRICS_MEASURES_GRP_ID, B.SRC_TABLE_ID SRC_TABLE_ID, B.TARGET_TABLE_ID TARGET_TABLE_ID, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, T.NAME NAME, T.DESCRIPTION DESCRIPTION, T.LANGUAGE LANGUAGE, T.SOURCE_LANG SOURCE_LANG, B.SRC_FQ_ENTITY_NAME SRC_FQ_ENTITY_NAME, B.SRC_FQ_VIEW_NAME SRC_FQ_VIEW_NAME, B.TARGET_FQ_ENTITY_NAME TARGET_FQ_ENTITY_NAME, B.TARGET_FQ_VIEW_NAME TARGET_FQ_VIEW_NAME FROM ACD_METRICS_MEAS_GRP_B B, ACD_METRICS_MEAS_GRP_TL T WHERE B.METRICS_MEASURES_GRP_ID = T.METRICS_MEASURES_GRP_ID AND T.LANGUAGE = USERENV('LANG') |