QP_MATRIX_DIMENSIONS

Details

Schema: FUSION
Object owner: QP
Object type: VIEW

Columns

Name
DYNAMIC_MATRIX_DIMENSION_ID DYN_MATRIX_DIMENSION_GUID DYNAMIC_MATRIX_DIMENSION_NAME DYNAMIC_MATRIX_CLASS_ID DIMENSION_TYPE DATA_TYPE_CODE DOMAIN_TYPE_CODE DISPLAY_SEQUENCE_NUM IS_NULLABLE_FLAG NULL_AS_WILD_CARD_FLAG DISP_DEFVAL_ADMIN_UI_FLAG DYNAMIC_MATRIX_ID SOURCE_CODE_NAME DOMAIN_LOOK_UP_CODE APP_MODULE_NAME APP_CONFIG DOMAIN_VO_NAME DOMAIN_VO_VC_NAME DOMAIN_VO_KEY_ATTR DOMAIN_VO_DISPLAY_ATTR DEFAULT_VALUE_NUMBER DEFAULT_VALUE_TEXT DEFAULT_VALUE_TIMESTAMP DEFAULT_VALUE_DATE DEFAULT_FIXED_VALUE_FLAG COMPARISON_OPERATOR_CODE COMPARE_TO_ENTITY_CODE COMPARE_TO_ATTR_CODE FILTER_BY_ATTR1_CODE FILTER_BY_ATTR2_CODE FILTER_BY_ATTR1_VALUE FILTER_BY_ATTR2_VALUE REQD_DIMN_FOR_CLASS_EXPR MAP_TO_RULE_COL_NUM CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Name

DYNAMIC_MATRIX_DIMENSION_ID

DYN_MATRIX_DIMENSION_GUID

DYNAMIC_MATRIX_DIMENSION_NAME

DYNAMIC_MATRIX_CLASS_ID

DIMENSION_TYPE

DATA_TYPE_CODE

DOMAIN_TYPE_CODE

DISPLAY_SEQUENCE_NUM

IS_NULLABLE_FLAG

NULL_AS_WILD_CARD_FLAG

DISP_DEFVAL_ADMIN_UI_FLAG

DYNAMIC_MATRIX_ID

SOURCE_CODE_NAME

DOMAIN_LOOK_UP_CODE

APP_MODULE_NAME

APP_CONFIG

DOMAIN_VO_NAME

DOMAIN_VO_VC_NAME

DOMAIN_VO_KEY_ATTR

DOMAIN_VO_DISPLAY_ATTR

DEFAULT_VALUE_NUMBER

DEFAULT_VALUE_TEXT

DEFAULT_VALUE_TIMESTAMP

DEFAULT_VALUE_DATE

DEFAULT_FIXED_VALUE_FLAG

COMPARISON_OPERATOR_CODE

COMPARE_TO_ENTITY_CODE

COMPARE_TO_ATTR_CODE

FILTER_BY_ATTR1_CODE

FILTER_BY_ATTR2_CODE

FILTER_BY_ATTR1_VALUE

FILTER_BY_ATTR2_VALUE

REQD_DIMN_FOR_CLASS_EXPR

MAP_TO_RULE_COL_NUM

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement
SELECT QP_MATRIX_DIMENSIONS_B.DYNAMIC_MATRIX_DIMENSION_ID DYNAMIC_MATRIX_DIMENSION_ID, QP_MATRIX_DIMENSIONS_B.DYN_MATRIX_DIMENSION_GUID DYN_MATRIX_DIMENSION_GUID, QP_MATRIX_DIMENSIONS_TL.DYNAMIC_MATRIX_DIMENSION_NAME DYNAMIC_MATRIX_DIMENSION_NAME, QP_MATRIX_DIMENSIONS_B.DYNAMIC_MATRIX_CLASS_ID DYNAMIC_MATRIX_CLASS_ID, QP_MATRIX_DIMENSIONS_B.DIMENSION_TYPE DIMENSION_TYPE, QP_MATRIX_DIMENSIONS_B.DATA_TYPE_CODE DATA_TYPE_CODE, QP_MATRIX_DIMENSIONS_B.DOMAIN_TYPE_CODE DOMAIN_TYPE_CODE, QP_MATRIX_DIMENSIONS_B.DISPLAY_SEQUENCE_NUM DISPLAY_SEQUENCE_NUM, QP_MATRIX_DIMENSIONS_B.IS_NULLABLE_FLAG IS_NULLABLE_FLAG, QP_MATRIX_DIMENSIONS_B.NULL_AS_WILD_CARD_FLAG NULL_AS_WILD_CARD_FLAG, QP_MATRIX_DIMENSIONS_B.DISP_DEFVAL_ADMIN_UI_FLAG DISP_DEFVAL_ADMIN_UI_FLAG, QP_MATRIX_DIMENSIONS_B.DYNAMIC_MATRIX_ID DYNAMIC_MATRIX_ID, QP_MATRIX_DIMENSIONS_B.SOURCE_CODE_NAME SOURCE_CODE_NAME, QP_MATRIX_DIMENSIONS_B.DOMAIN_LOOK_UP_CODE DOMAIN_LOOK_UP_CODE, QP_MATRIX_DIMENSIONS_B.APP_MODULE_NAME APP_MODULE_NAME, QP_MATRIX_DIMENSIONS_B.APP_CONFIG APP_CONFIG, QP_MATRIX_DIMENSIONS_B.DOMAIN_VO_NAME DOMAIN_VO_NAME, QP_MATRIX_DIMENSIONS_B.DOMAIN_VO_VC_NAME DOMAIN_VO_VC_NAME, QP_MATRIX_DIMENSIONS_B.DOMAIN_VO_KEY_ATTR DOMAIN_VO_KEY_ATTR, QP_MATRIX_DIMENSIONS_B.DOMAIN_VO_DISPLAY_ATTR DOMAIN_VO_DISPLAY_ATTR, QP_MATRIX_DIMENSIONS_B.DEFAULT_VALUE_NUMBER DEFAULT_VALUE_NUMBER, QP_MATRIX_DIMENSIONS_B.DEFAULT_VALUE_TEXT DEFAULT_VALUE_TEXT, QP_MATRIX_DIMENSIONS_B.DEFAULT_VALUE_TIMESTAMP DEFAULT_VALUE_TIMESTAMP, QP_MATRIX_DIMENSIONS_B.DEFAULT_VALUE_DATE DEFAULT_VALUE_DATE, QP_MATRIX_DIMENSIONS_B.DEFAULT_FIXED_VALUE_FLAG DEFAULT_FIXED_VALUE_FLAG, QP_MATRIX_DIMENSIONS_B.COMPARISON_OPERATOR_CODE COMPARISON_OPERATOR_CODE, QP_MATRIX_DIMENSIONS_B.COMPARE_TO_ENTITY_CODE COMPARE_TO_ENTITY_CODE, QP_MATRIX_DIMENSIONS_B.COMPARE_TO_ATTR_CODE COMPARE_TO_ATTR_CODE, QP_MATRIX_DIMENSIONS_B.FILTER_BY_ATTR1_CODE FILTER_BY_ATTR1_CODE, QP_MATRIX_DIMENSIONS_B.FILTER_BY_ATTR2_CODE FILTER_BY_ATTR2_CODE, QP_MATRIX_DIMENSIONS_B.FILTER_BY_ATTR1_VALUE FILTER_BY_ATTR1_VALUE, QP_MATRIX_DIMENSIONS_B.FILTER_BY_ATTR2_VALUE FILTER_BY_ATTR2_VALUE, QP_MATRIX_DIMENSIONS_B.REQD_DIMN_FOR_CLASS_EXPR REQD_DIMN_FOR_CLASS_EXPR, QP_MATRIX_DIMENSIONS_B.MAP_TO_RULE_COL_NUM MAP_TO_RULE_COL_NUM, QP_MATRIX_DIMENSIONS_B.CREATED_BY CREATED_BY, QP_MATRIX_DIMENSIONS_B.CREATION_DATE CREATION_DATE, QP_MATRIX_DIMENSIONS_B.LAST_UPDATED_BY LAST_UPDATED_BY, QP_MATRIX_DIMENSIONS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, QP_MATRIX_DIMENSIONS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, QP_MATRIX_DIMENSIONS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM QP_MATRIX_DIMENSIONS_B, QP_MATRIX_DIMENSIONS_TL WHERE QP_MATRIX_DIMENSIONS_B.DYNAMIC_MATRIX_DIMENSION_ID = QP_MATRIX_DIMENSIONS_TL.DYNAMIC_MATRIX_DIMENSION_ID AND QP_MATRIX_DIMENSIONS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

QP_MATRIX_DIMENSIONS_B.DYNAMIC_MATRIX_DIMENSION_ID DYNAMIC_MATRIX_DIMENSION_ID,

QP_MATRIX_DIMENSIONS_B.DYN_MATRIX_DIMENSION_GUID DYN_MATRIX_DIMENSION_GUID,

QP_MATRIX_DIMENSIONS_TL.DYNAMIC_MATRIX_DIMENSION_NAME DYNAMIC_MATRIX_DIMENSION_NAME,

QP_MATRIX_DIMENSIONS_B.DYNAMIC_MATRIX_CLASS_ID DYNAMIC_MATRIX_CLASS_ID,

QP_MATRIX_DIMENSIONS_B.DIMENSION_TYPE DIMENSION_TYPE,

QP_MATRIX_DIMENSIONS_B.DATA_TYPE_CODE DATA_TYPE_CODE,

QP_MATRIX_DIMENSIONS_B.DOMAIN_TYPE_CODE DOMAIN_TYPE_CODE,

QP_MATRIX_DIMENSIONS_B.DISPLAY_SEQUENCE_NUM DISPLAY_SEQUENCE_NUM,

QP_MATRIX_DIMENSIONS_B.IS_NULLABLE_FLAG IS_NULLABLE_FLAG,

QP_MATRIX_DIMENSIONS_B.NULL_AS_WILD_CARD_FLAG NULL_AS_WILD_CARD_FLAG,

QP_MATRIX_DIMENSIONS_B.DISP_DEFVAL_ADMIN_UI_FLAG DISP_DEFVAL_ADMIN_UI_FLAG,

QP_MATRIX_DIMENSIONS_B.DYNAMIC_MATRIX_ID DYNAMIC_MATRIX_ID,

QP_MATRIX_DIMENSIONS_B.SOURCE_CODE_NAME SOURCE_CODE_NAME,

QP_MATRIX_DIMENSIONS_B.DOMAIN_LOOK_UP_CODE DOMAIN_LOOK_UP_CODE,

QP_MATRIX_DIMENSIONS_B.APP_MODULE_NAME APP_MODULE_NAME,

QP_MATRIX_DIMENSIONS_B.APP_CONFIG APP_CONFIG,

QP_MATRIX_DIMENSIONS_B.DOMAIN_VO_NAME DOMAIN_VO_NAME,

QP_MATRIX_DIMENSIONS_B.DOMAIN_VO_VC_NAME DOMAIN_VO_VC_NAME,

QP_MATRIX_DIMENSIONS_B.DOMAIN_VO_KEY_ATTR DOMAIN_VO_KEY_ATTR,

QP_MATRIX_DIMENSIONS_B.DOMAIN_VO_DISPLAY_ATTR DOMAIN_VO_DISPLAY_ATTR,

QP_MATRIX_DIMENSIONS_B.DEFAULT_VALUE_NUMBER DEFAULT_VALUE_NUMBER,

QP_MATRIX_DIMENSIONS_B.DEFAULT_VALUE_TEXT DEFAULT_VALUE_TEXT,

QP_MATRIX_DIMENSIONS_B.DEFAULT_VALUE_TIMESTAMP DEFAULT_VALUE_TIMESTAMP,

QP_MATRIX_DIMENSIONS_B.DEFAULT_VALUE_DATE DEFAULT_VALUE_DATE,

QP_MATRIX_DIMENSIONS_B.DEFAULT_FIXED_VALUE_FLAG DEFAULT_FIXED_VALUE_FLAG,

QP_MATRIX_DIMENSIONS_B.COMPARISON_OPERATOR_CODE COMPARISON_OPERATOR_CODE,

QP_MATRIX_DIMENSIONS_B.COMPARE_TO_ENTITY_CODE COMPARE_TO_ENTITY_CODE,

QP_MATRIX_DIMENSIONS_B.COMPARE_TO_ATTR_CODE COMPARE_TO_ATTR_CODE,

QP_MATRIX_DIMENSIONS_B.FILTER_BY_ATTR1_CODE FILTER_BY_ATTR1_CODE,

QP_MATRIX_DIMENSIONS_B.FILTER_BY_ATTR2_CODE FILTER_BY_ATTR2_CODE,

QP_MATRIX_DIMENSIONS_B.FILTER_BY_ATTR1_VALUE FILTER_BY_ATTR1_VALUE,

QP_MATRIX_DIMENSIONS_B.FILTER_BY_ATTR2_VALUE FILTER_BY_ATTR2_VALUE,

QP_MATRIX_DIMENSIONS_B.REQD_DIMN_FOR_CLASS_EXPR REQD_DIMN_FOR_CLASS_EXPR,

QP_MATRIX_DIMENSIONS_B.MAP_TO_RULE_COL_NUM MAP_TO_RULE_COL_NUM,

QP_MATRIX_DIMENSIONS_B.CREATED_BY CREATED_BY,

QP_MATRIX_DIMENSIONS_B.CREATION_DATE CREATION_DATE,

QP_MATRIX_DIMENSIONS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

QP_MATRIX_DIMENSIONS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

QP_MATRIX_DIMENSIONS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

QP_MATRIX_DIMENSIONS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER

FROM

QP_MATRIX_DIMENSIONS_B,

QP_MATRIX_DIMENSIONS_TL

WHERE

QP_MATRIX_DIMENSIONS_B.DYNAMIC_MATRIX_DIMENSION_ID = QP_MATRIX_DIMENSIONS_TL.DYNAMIC_MATRIX_DIMENSION_ID AND QP_MATRIX_DIMENSIONS_TL.LANGUAGE = USERENV('LANG')