QP_MATRIX_CLASSES_VL

Details

• Schema: FUSION

• Object owner: QP

• Object type: VIEW

Columns

Name
DYNAMIC_MATRIX_CLASS_ID MATRIX_CLASS_GUID USAGE_CODE CONTEXT_CONSUMER ADD_NEW_DIMENSIONS_FLAG DATE_EFF_ENABLED_FLAG MODULE_ID OWNER_APPLICATION PUBLIC_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER DYNAMIC_MATRIX_CLASS_NAME

Query

SQL_Statement

SELECT QP_MATRIX_CLASSES_B.DYNAMIC_MATRIX_CLASS_ID DYNAMIC_MATRIX_CLASS_ID, QP_MATRIX_CLASSES_B.MATRIX_CLASS_GUID MATRIX_CLASS_GUID, QP_MATRIX_CLASSES_B.USAGE_CODE USAGE_CODE, QP_MATRIX_CLASSES_B.CONTEXT_CONSUMER CONTEXT_CONSUMER, QP_MATRIX_CLASSES_B.ADD_NEW_DIMENSIONS_FLAG ADD_NEW_DIMENSIONS_FLAG, QP_MATRIX_CLASSES_B.DATE_EFF_ENABLED_FLAG DATE_EFF_ENABLED_FLAG, QP_MATRIX_CLASSES_B.MODULE_ID MODULE_ID, QP_MATRIX_CLASSES_B.OWNER_APPLICATION OWNER_APPLICATION, QP_MATRIX_CLASSES_B.PUBLIC_FLAG PUBLIC_FLAG, QP_MATRIX_CLASSES_B.CREATED_BY CREATED_BY, QP_MATRIX_CLASSES_B.CREATION_DATE CREATION_DATE, QP_MATRIX_CLASSES_B.LAST_UPDATED_BY LAST_UPDATED_BY, QP_MATRIX_CLASSES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, QP_MATRIX_CLASSES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, QP_MATRIX_CLASSES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, QP_MATRIX_CLASSES_TL.DYNAMIC_MATRIX_CLASS_NAME DYNAMIC_MATRIX_CLASS_NAME FROM QP_MATRIX_CLASSES_B, QP_MATRIX_CLASSES_TL WHERE QP_MATRIX_CLASSES_B.DYNAMIC_MATRIX_CLASS_ID = QP_MATRIX_CLASSES_TL.DYNAMIC_MATRIX_CLASS_ID AND QP_MATRIX_CLASSES_TL.LANGUAGE = USERENV('LANG')