HWM_RULE_TMPLTS_VL

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name

RULE_TMPLTS_ID OBJECT_VERSION_NUMBER ENTERPRISE_ID PROCESS_TYPE PRS_FORMULA_ID PRS_SCRIPT_ID PROCESS_NAME TEMPLATE_TYPE TEMPLATE_NAME CLASSIFICATION RUN_SUMMATION_LEVEL RUN_TBB_LEVEL RULE_EXEC_TYPE RUN_EVENT_SAVE RUN_EVENT_SUB RUN_EVENT_RESUB RUN_EVENT_DELETE SUPPRESS_DUP_MSGS INCLUDE_EMPTY_TC SEEDED_FLAG RULE_SUB_TYPE FAST_FORMULA_EXEC_TYPE DFLT_ALLOCATION_ID JAVA_CLASS JAVA_METHOD DESCRIPTION RT_EXPLANATION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN MODULE_ID

Query

SQL_Statement

SELECT TMPLTS.RULE_TMPLTS_ID, TMPLTS.OBJECT_VERSION_NUMBER, TMPLTS.ENTERPRISE_ID, TMPLTS.PROCESS_TYPE, TMPLTS.PRS_FORMULA_ID, TMPLTS.PRS_SCRIPT_ID, TMPLTS.PROCESS_NAME, TMPLTS.TEMPLATE_TYPE, TMPLTS.TEMPLATE_NAME, TMPLTS.CLASSIFICATION, TMPLTS.RUN_SUMMATION_LEVEL, TMPLTS.RUN_TBB_LEVEL, TMPLTS.RULE_EXEC_TYPE, TMPLTS.RUN_EVENT_SAVE, TMPLTS.RUN_EVENT_SUB, TMPLTS.RUN_EVENT_RESUB, TMPLTS.RUN_EVENT_DELETE , TMPLTS.SUPPRESS_DUP_MSGS, TMPLTS.INCLUDE_EMPTY_TC, TMPLTS.SEEDED_FLAG, TMPLTS.RULE_SUB_TYPE, TMPLTS.FAST_FORMULA_EXEC_TYPE, TMPLTS.DFLT_ALLOCATION_ID , TMPLTS.JAVA_CLASS , TMPLTS.JAVA_METHOD , TMPLTS_TL.DESCRIPTION, TMPLTS_TL.RT_EXPLANATION, TMPLTS.CREATED_BY, TMPLTS.CREATION_DATE, TMPLTS.LAST_UPDATED_BY, TMPLTS.LAST_UPDATE_DATE, TMPLTS.LAST_UPDATE_LOGIN, TMPLTS.MODULE_ID FROM HWM_RULE_TMPLTS TMPLTS, HWM_RULE_TMPLTS_TL TMPLTS_TL WHERE TMPLTS.RULE_TMPLTS_ID = TMPLTS_TL.RULE_TMPLTS_ID AND TMPLTS_TL.LANGUAGE = USERENV('LANG')