MOW_ASSESS_TEMPLATES

Details

Schema: FUSION
Object owner: MOW
Object type: VIEW

Columns

Name
ASSESS_TEMPLATE_ID ASSESSED_OBJ_TYPE_CODE RELATED_OBJ_TYPE_CODE SET_ID ADMIN_BU_ID STATUS_CODE AUTO_TRIGGER_FLAG FREEFORM_TEXT_FLAG PUBLIC_FLAG COLOR_GRAPH_FLAG DELETED_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER NAME DESC_TEXT COMMENTS ASSESS_TEMPLATE_NUMBER MODULE_ID SCORE_RANGE_OVERRIDE_FLAG

Name

ASSESS_TEMPLATE_ID

ASSESSED_OBJ_TYPE_CODE

RELATED_OBJ_TYPE_CODE

SET_ID

ADMIN_BU_ID

STATUS_CODE

AUTO_TRIGGER_FLAG

FREEFORM_TEXT_FLAG

PUBLIC_FLAG

COLOR_GRAPH_FLAG

DELETED_FLAG

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

NAME

DESC_TEXT

COMMENTS

ASSESS_TEMPLATE_NUMBER

MODULE_ID

SCORE_RANGE_OVERRIDE_FLAG

Query

SQL_Statement
SELECT MOW_ASSESS_TEMPLATES_B.ASSESS_TEMPLATE_ID ASSESS_TEMPLATE_ID, MOW_ASSESS_TEMPLATES_B.ASSESSED_OBJ_TYPE_CODE ASSESSED_OBJ_TYPE_CODE, MOW_ASSESS_TEMPLATES_B.RELATED_OBJ_TYPE_CODE RELATED_OBJ_TYPE_CODE, MOW_ASSESS_TEMPLATES_B.SET_ID SET_ID, MOW_ASSESS_TEMPLATES_B.ADMIN_BU_ID ADMIN_BU_ID, MOW_ASSESS_TEMPLATES_B.STATUS_CODE STATUS_CODE, MOW_ASSESS_TEMPLATES_B.AUTO_TRIGGER_FLAG AUTO_TRIGGER_FLAG, MOW_ASSESS_TEMPLATES_B.FREEFORM_TEXT_FLAG FREEFORM_TEXT_FLAG, MOW_ASSESS_TEMPLATES_B.PUBLIC_FLAG PUBLIC_FLAG, MOW_ASSESS_TEMPLATES_B.COLOR_GRAPH_FLAG COLOR_GRAPH_FLAG, MOW_ASSESS_TEMPLATES_B.DELETED_FLAG DELETED_FLAG, MOW_ASSESS_TEMPLATES_B.CREATED_BY CREATED_BY, MOW_ASSESS_TEMPLATES_B.CREATION_DATE CREATION_DATE, MOW_ASSESS_TEMPLATES_B.LAST_UPDATED_BY LAST_UPDATED_BY, MOW_ASSESS_TEMPLATES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, MOW_ASSESS_TEMPLATES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MOW_ASSESS_TEMPLATES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, MOW_ASSESS_TEMPLATES_TL.NAME NAME, MOW_ASSESS_TEMPLATES_TL.DESC_TEXT DESC_TEXT, MOW_ASSESS_TEMPLATES_TL.COMMENTS COMMENTS, MOW_ASSESS_TEMPLATES_B.ASSESS_TEMPLATE_NUMBER ASSESS_TEMPLATE_NUMBER, MOW_ASSESS_TEMPLATES_B.MODULE_ID MODULE_ID, MOW_ASSESS_TEMPLATES_B.SCORE_RANGE_OVERRIDE_FLAG SCORE_RANGE_OVERRIDE_FLAG FROM MOW_ASSESS_TEMPLATES_B, MOW_ASSESS_TEMPLATES_TL WHERE MOW_ASSESS_TEMPLATES_B.ASSESS_TEMPLATE_ID = MOW_ASSESS_TEMPLATES_TL.ASSESS_TEMPLATE_ID AND MOW_ASSESS_TEMPLATES_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

MOW_ASSESS_TEMPLATES_B.ASSESS_TEMPLATE_ID ASSESS_TEMPLATE_ID,

MOW_ASSESS_TEMPLATES_B.ASSESSED_OBJ_TYPE_CODE ASSESSED_OBJ_TYPE_CODE,

MOW_ASSESS_TEMPLATES_B.RELATED_OBJ_TYPE_CODE RELATED_OBJ_TYPE_CODE,

MOW_ASSESS_TEMPLATES_B.SET_ID SET_ID,

MOW_ASSESS_TEMPLATES_B.ADMIN_BU_ID ADMIN_BU_ID,

MOW_ASSESS_TEMPLATES_B.STATUS_CODE STATUS_CODE,

MOW_ASSESS_TEMPLATES_B.AUTO_TRIGGER_FLAG AUTO_TRIGGER_FLAG,

MOW_ASSESS_TEMPLATES_B.FREEFORM_TEXT_FLAG FREEFORM_TEXT_FLAG,

MOW_ASSESS_TEMPLATES_B.PUBLIC_FLAG PUBLIC_FLAG,

MOW_ASSESS_TEMPLATES_B.COLOR_GRAPH_FLAG COLOR_GRAPH_FLAG,

MOW_ASSESS_TEMPLATES_B.DELETED_FLAG DELETED_FLAG,

MOW_ASSESS_TEMPLATES_B.CREATED_BY CREATED_BY,

MOW_ASSESS_TEMPLATES_B.CREATION_DATE CREATION_DATE,

MOW_ASSESS_TEMPLATES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

MOW_ASSESS_TEMPLATES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

MOW_ASSESS_TEMPLATES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

MOW_ASSESS_TEMPLATES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

MOW_ASSESS_TEMPLATES_TL.NAME NAME,

MOW_ASSESS_TEMPLATES_TL.DESC_TEXT DESC_TEXT,

MOW_ASSESS_TEMPLATES_TL.COMMENTS COMMENTS,

MOW_ASSESS_TEMPLATES_B.ASSESS_TEMPLATE_NUMBER ASSESS_TEMPLATE_NUMBER,

MOW_ASSESS_TEMPLATES_B.MODULE_ID MODULE_ID,

MOW_ASSESS_TEMPLATES_B.SCORE_RANGE_OVERRIDE_FLAG SCORE_RANGE_OVERRIDE_FLAG

FROM

MOW_ASSESS_TEMPLATES_B,

MOW_ASSESS_TEMPLATES_TL

WHERE

MOW_ASSESS_TEMPLATES_B.ASSESS_TEMPLATE_ID = MOW_ASSESS_TEMPLATES_TL.ASSESS_TEMPLATE_ID AND MOW_ASSESS_TEMPLATES_TL.LANGUAGE = USERENV('LANG')