MOW_SUGGESTED_ACT_TEMPLS_VL

Details

• Schema: FUSION

• Object owner: MOW

• Object type: VIEW

Columns

Name
SUGGESTED_ACT_TEMPLATE_ID ASSESS_TEMPLATE_ID ACTIVITY_TEMPLATE_ID DESC_TEXT DELETED_FLAG FILTER_LOW_SCORE FILTER_HIGH_SCORE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SUGGESTED_ACT_TEMPLATE_NUMBER

Query

SQL_Statement

SELECT MOW_SUGGESTED_ACT_TEMPLS_B.SUGGESTED_ACT_TEMPLATE_ID SUGGESTED_ACT_TEMPLATE_ID, MOW_SUGGESTED_ACT_TEMPLS_B.ASSESS_TEMPLATE_ID ASSESS_TEMPLATE_ID, MOW_SUGGESTED_ACT_TEMPLS_B.ACTIVITY_TEMPLATE_ID ACTIVITY_TEMPLATE_ID, MOW_SUGGESTED_ACT_TEMPLS_TL.DESC_TEXT DESC_TEXT, MOW_SUGGESTED_ACT_TEMPLS_B.DELETED_FLAG DELETED_FLAG, MOW_SUGGESTED_ACT_TEMPLS_B.FILTER_LOW_SCORE FILTER_LOW_SCORE, MOW_SUGGESTED_ACT_TEMPLS_B.FILTER_HIGH_SCORE FILTER_HIGH_SCORE, MOW_SUGGESTED_ACT_TEMPLS_B.CREATED_BY CREATED_BY, MOW_SUGGESTED_ACT_TEMPLS_B.CREATION_DATE CREATION_DATE, MOW_SUGGESTED_ACT_TEMPLS_B.LAST_UPDATED_BY LAST_UPDATED_BY, MOW_SUGGESTED_ACT_TEMPLS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, MOW_SUGGESTED_ACT_TEMPLS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MOW_SUGGESTED_ACT_TEMPLS_B.SUGGESTED_ACT_TEMPLATE_NUMBER SUGGESTED_ACT_TEMPLATE_NUMBER FROM MOW_SUGGESTED_ACT_TEMPLS_B, MOW_SUGGESTED_ACT_TEMPLS_TL WHERE MOW_SUGGESTED_ACT_TEMPLS_B.SUGGESTED_ACT_TEMPLATE_ID = MOW_SUGGESTED_ACT_TEMPLS_TL.SUGGESTED_ACT_TEMPLATE_ID (+) AND MOW_SUGGESTED_ACT_TEMPLS_TL.LANGUAGE (+) = USERENV('LANG')