CMP_TCS_FEEDBACK_V

Details

  • Schema: FUSION

  • Object owner: CMP

  • Object type: VIEW

Columns

Name

FEEDBACK_ID

STMT_ID

STMT_PERD_ID

RATING_ENABLED_FLAG

RATING_INSTRUCTION

QUESTION1

QUESTION2

QUESTION3

QUESTION4

QUESTION5

QUESTION1_REQUIRED_FLAG

QUESTION2_REQUIRED_FLAG

QUESTION3_REQUIRED_FLAG

QUESTION4_REQUIRED_FLAG

QUESTION5_REQUIRED_FLAG

OBJECT_VERSION_NUMBER

LANGUAGE

SOURCE_LANG

CREATED_BY

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

CREATION_DATE

Query

SQL_Statement

SELECT

FEEDBACK.FEEDBACK_ID,

FEEDBACK.STMT_ID ,

FEEDBACK.STMT_PERD_ID ,

FEEDBACK.RATING_ENABLED_FLAG ,

FEEDBACK_TL.RATING_INSTRUCTION ,

FEEDBACK_TL.QUESTION1 ,

FEEDBACK_TL.QUESTION2 ,

FEEDBACK_TL.QUESTION3 ,

FEEDBACK_TL.QUESTION4 ,

FEEDBACK_TL.QUESTION5 ,

FEEDBACK.QUESTION1_REQUIRED_FLAG ,

FEEDBACK.QUESTION2_REQUIRED_FLAG ,

FEEDBACK.QUESTION3_REQUIRED_FLAG ,

FEEDBACK.QUESTION4_REQUIRED_FLAG ,

FEEDBACK.QUESTION5_REQUIRED_FLAG ,

FEEDBACK.OBJECT_VERSION_NUMBER ,

FEEDBACK_TL.LANGUAGE,

FEEDBACK_TL.SOURCE_LANG ,

FEEDBACK.CREATED_BY ,

FEEDBACK.LAST_UPDATED_BY ,

FEEDBACK.LAST_UPDATE_DATE ,

FEEDBACK.LAST_UPDATE_LOGIN ,

FEEDBACK.CREATION_DATE

FROM

CMP_TCS_FEEDBACK_B FEEDBACK,

CMP_TCS_FEEDBACK_TL FEEDBACK_TL

WHERE

FEEDBACK.FEEDBACK_ID = FEEDBACK_TL.FEEDBACK_ID