HWM_TCAT_EXPR_RESULTS

Details

Schema: FUSION
Object owner: HWM
Object type: VIEW

Columns

Name
TCAT_EXPR_RESULT_ID TCAT_ID DISPLAY_SEQUENCE EXPRESSION_GROUP_ID USER_DESCRIPTION LEFT_PARENTHESIS_NUM TIME_ATRB_FLD_ID VALUE_TYPE VALUE_ID OPERATOR RIGHT_PARENTHESIS_NUM EXPR_ROW_IDENTIFIER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY OBJECT_VERSION_NUMBER ENTERPRISE_ID DISPLAY_VALUE VALUE_CHAR VALUE_DATE VALUE_TIMESTAMP SGUID

Name

TCAT_EXPR_RESULT_ID

TCAT_ID

DISPLAY_SEQUENCE

EXPRESSION_GROUP_ID

USER_DESCRIPTION

LEFT_PARENTHESIS_NUM

TIME_ATRB_FLD_ID

VALUE_TYPE

VALUE_ID

OPERATOR

RIGHT_PARENTHESIS_NUM

EXPR_ROW_IDENTIFIER

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

OBJECT_VERSION_NUMBER

ENTERPRISE_ID

DISPLAY_VALUE

VALUE_CHAR

VALUE_DATE

VALUE_TIMESTAMP

SGUID

Query

SQL_Statement
SELECT HWM_TCAT_EXPR_RESULTS_B.TCAT_EXPR_RESULT_ID TCAT_EXPR_RESULT_ID, HWM_TCAT_EXPR_RESULTS_B.TCAT_ID TCAT_ID, HWM_TCAT_EXPR_RESULTS_B.DISPLAY_SEQUENCE DISPLAY_SEQUENCE, HWM_TCAT_EXPR_RESULTS_B.EXPRESSION_GROUP_ID EXPRESSION_GROUP_ID, HWM_TCAT_EXPR_RESULTS_TL.USER_DESCRIPTION USER_DESCRIPTION, HWM_TCAT_EXPR_RESULTS_B.LEFT_PARENTHESIS_NUM LEFT_PARENTHESIS_NUM, HWM_TCAT_EXPR_RESULTS_B.TIME_ATRB_FLD_ID TIME_ATRB_FLD_ID, HWM_TCAT_EXPR_RESULTS_B.VALUE_TYPE VALUE_TYPE, HWM_TCAT_EXPR_RESULTS_B.VALUE_ID VALUE_ID, HWM_TCAT_EXPR_RESULTS_B.OPERATOR OPERATOR, HWM_TCAT_EXPR_RESULTS_B.RIGHT_PARENTHESIS_NUM RIGHT_PARENTHESIS_NUM, HWM_TCAT_EXPR_RESULTS_B.EXPR_ROW_IDENTIFIER EXPR_ROW_IDENTIFIER, HWM_TCAT_EXPR_RESULTS_B.CREATED_BY CREATED_BY, HWM_TCAT_EXPR_RESULTS_B.CREATION_DATE CREATION_DATE, HWM_TCAT_EXPR_RESULTS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, HWM_TCAT_EXPR_RESULTS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, HWM_TCAT_EXPR_RESULTS_B.LAST_UPDATED_BY LAST_UPDATED_BY, HWM_TCAT_EXPR_RESULTS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, HWM_TCAT_EXPR_RESULTS_B.ENTERPRISE_ID ENTERPRISE_ID, HWM_TCAT_EXPR_RESULTS_B.DISPLAY_VALUE DISPLAY_VALUE, HWM_TCAT_EXPR_RESULTS_B.VALUE_CHAR VALUE_CHAR, HWM_TCAT_EXPR_RESULTS_B.VALUE_DATE VALUE_DATE, HWM_TCAT_EXPR_RESULTS_B.VALUE_TIMESTAMP VALUE_TIMESTAMP, HWM_TCAT_EXPR_RESULTS_B.SGUID SGUID FROM HWM_TCAT_EXPR_RESULTS_B, HWM_TCAT_EXPR_RESULTS_TL WHERE HWM_TCAT_EXPR_RESULTS_B.TCAT_EXPR_RESULT_ID = HWM_TCAT_EXPR_RESULTS_TL.TCAT_EXPR_RESULT_ID AND HWM_TCAT_EXPR_RESULTS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

HWM_TCAT_EXPR_RESULTS_B.TCAT_EXPR_RESULT_ID TCAT_EXPR_RESULT_ID,

HWM_TCAT_EXPR_RESULTS_B.TCAT_ID TCAT_ID,

HWM_TCAT_EXPR_RESULTS_B.DISPLAY_SEQUENCE DISPLAY_SEQUENCE,

HWM_TCAT_EXPR_RESULTS_B.EXPRESSION_GROUP_ID EXPRESSION_GROUP_ID,

HWM_TCAT_EXPR_RESULTS_TL.USER_DESCRIPTION USER_DESCRIPTION,

HWM_TCAT_EXPR_RESULTS_B.LEFT_PARENTHESIS_NUM LEFT_PARENTHESIS_NUM,

HWM_TCAT_EXPR_RESULTS_B.TIME_ATRB_FLD_ID TIME_ATRB_FLD_ID,

HWM_TCAT_EXPR_RESULTS_B.VALUE_TYPE VALUE_TYPE,

HWM_TCAT_EXPR_RESULTS_B.VALUE_ID VALUE_ID,

HWM_TCAT_EXPR_RESULTS_B.OPERATOR OPERATOR,

HWM_TCAT_EXPR_RESULTS_B.RIGHT_PARENTHESIS_NUM RIGHT_PARENTHESIS_NUM,

HWM_TCAT_EXPR_RESULTS_B.EXPR_ROW_IDENTIFIER EXPR_ROW_IDENTIFIER,

HWM_TCAT_EXPR_RESULTS_B.CREATED_BY CREATED_BY,

HWM_TCAT_EXPR_RESULTS_B.CREATION_DATE CREATION_DATE,

HWM_TCAT_EXPR_RESULTS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

HWM_TCAT_EXPR_RESULTS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

HWM_TCAT_EXPR_RESULTS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

HWM_TCAT_EXPR_RESULTS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

HWM_TCAT_EXPR_RESULTS_B.ENTERPRISE_ID ENTERPRISE_ID,

HWM_TCAT_EXPR_RESULTS_B.DISPLAY_VALUE DISPLAY_VALUE,

HWM_TCAT_EXPR_RESULTS_B.VALUE_CHAR VALUE_CHAR,

HWM_TCAT_EXPR_RESULTS_B.VALUE_DATE VALUE_DATE,

HWM_TCAT_EXPR_RESULTS_B.VALUE_TIMESTAMP VALUE_TIMESTAMP,

HWM_TCAT_EXPR_RESULTS_B.SGUID SGUID

FROM

HWM_TCAT_EXPR_RESULTS_B,

HWM_TCAT_EXPR_RESULTS_TL

WHERE

HWM_TCAT_EXPR_RESULTS_B.TCAT_EXPR_RESULT_ID = HWM_TCAT_EXPR_RESULTS_TL.TCAT_EXPR_RESULT_ID AND HWM_TCAT_EXPR_RESULTS_TL.LANGUAGE = USERENV('LANG')