1. Tables and Views for SCM
  2. QP_MATRIX_DOMAINS_VL

QP_MATRIX_DOMAINS_VL

Details

  • Schema: FUSION

  • Object owner: QP

  • Object type: VIEW

Columns

Name

DYNAMIC_MATRIX_DOMAIN_ID

DYNAMIC_MATRIX_DOMAIN_GUID

DYNAMIC_MATRIX_DIMENSION_ID

DISPLAY_VALUE

VALUE_STRING

VALUE_NUMBER

VALUE_TIMESTAMP

VALUE_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT

QP_MATRIX_DOMAINS_B.DYNAMIC_MATRIX_DOMAIN_ID DYNAMIC_MATRIX_DOMAIN_ID,

QP_MATRIX_DOMAINS_B.DYNAMIC_MATRIX_DOMAIN_GUID DYNAMIC_MATRIX_DOMAIN_GUID,

QP_MATRIX_DOMAINS_B.DYNAMIC_MATRIX_DIMENSION_ID DYNAMIC_MATRIX_DIMENSION_ID,

QP_MATRIX_DOMAINS_TL.DISPLAY_VALUE DISPLAY_VALUE,

QP_MATRIX_DOMAINS_B.VALUE_STRING VALUE_STRING,

QP_MATRIX_DOMAINS_B.VALUE_NUMBER VALUE_NUMBER,

QP_MATRIX_DOMAINS_B.VALUE_TIMESTAMP VALUE_TIMESTAMP,

QP_MATRIX_DOMAINS_B.VALUE_DATE VALUE_DATE,

QP_MATRIX_DOMAINS_B.CREATED_BY CREATED_BY,

QP_MATRIX_DOMAINS_B.CREATION_DATE CREATION_DATE,

QP_MATRIX_DOMAINS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

QP_MATRIX_DOMAINS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

QP_MATRIX_DOMAINS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

QP_MATRIX_DOMAINS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER

FROM

QP_MATRIX_DOMAINS_B,

QP_MATRIX_DOMAINS_TL

WHERE

QP_MATRIX_DOMAINS_B.DYNAMIC_MATRIX_DOMAIN_ID = QP_MATRIX_DOMAINS_TL.DYNAMIC_MATRIX_DOMAIN_ID AND QP_MATRIX_DOMAINS_TL.LANGUAGE = USERENV('LANG')