HWM_RULE_TMPLT_USAGES_VL

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name
RULE_TMPLT_USAGES_ID OBJECT_VERSION_NUMBER ENTERPRISE_ID RULE_TMPLTS_ID ATRB_FLD_SET_ID TM_ATRB_FLD_ID ATRB_FLD_NAME OUTPUT_NAME OUTPUT_SOURCE TBB_GROUP_NUMBER DISPLAY_SEQUENCE HIDE_FLAG RECURSIVE MSG_SEVERITY OUTPUT_VALUE_TYPE VALUE_SET_ID RELATED_INPUT_NAME USER_DEFINED_OUT_NAME OUT_NAME_DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SGUID

Query

SQL_Statement

SELECT TMPLT_USAGES.RULE_TMPLT_USAGES_ID, TMPLT_USAGES.OBJECT_VERSION_NUMBER, TMPLT_USAGES.ENTERPRISE_ID, TMPLT_USAGES.RULE_TMPLTS_ID, TMPLT_USAGES.ATRB_FLD_SET_ID, TMPLT_USAGES.TM_ATRB_FLD_ID, TMPLT_USAGES.ATRB_FLD_NAME, TMPLT_USAGES.OUTPUT_NAME, TMPLT_USAGES.OUTPUT_SOURCE, TMPLT_USAGES.TBB_GROUP_NUMBER, TMPLT_USAGES.DISPLAY_SEQUENCE, TMPLT_USAGES.HIDE_FLAG, TMPLT_USAGES.RECURSIVE, TMPLT_USAGES.MSG_SEVERITY, TMPLT_USAGES.OUTPUT_VALUE_TYPE, TMPLT_USAGES.VALUE_SET_ID, TMPLT_USAGES.RELATED_INPUT_NAME, TMPLT_USAGES_TL.USER_DEFINED_OUT_NAME, TMPLT_USAGES_TL.OUT_NAME_DESCRIPTION, TMPLT_USAGES.CREATED_BY, TMPLT_USAGES.CREATION_DATE, TMPLT_USAGES.LAST_UPDATED_BY, TMPLT_USAGES.LAST_UPDATE_DATE, TMPLT_USAGES.LAST_UPDATE_LOGIN, TMPLT_USAGES.SGUID SGUID FROM HWM_RULE_TMPLT_USAGES TMPLT_USAGES, HWM_RULE_TMPLT_USAGES_TL TMPLT_USAGES_TL WHERE TMPLT_USAGES.RULE_TMPLT_USAGES_ID = TMPLT_USAGES_TL.RULE_TMPLT_USAGES_ID AND TMPLT_USAGES_TL.LANGUAGE = USERENV('LANG')