CMP_TCS_STMT_FEEDBACK_VL

Details

• Schema: FUSION

• Object owner: CMP

• Object type: VIEW

Columns

Name
STMT_FEEDBACK_ID STMT_ID STMT_PERD_ID PERD_RUN_ID QUESTION1_REQUIRED_FLAG QUESTION2_REQUIRED_FLAG QUESTION3_REQUIRED_FLAG QUESTION4_REQUIRED_FLAG QUESTION5_REQUIRED_FLAG LANGUAGE SOURCE_LANG RATING_INSTRUCTION QUESTION1 QUESTION2 QUESTION3 QUESTION4 QUESTION5 REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT FEEDBACK.STMT_FEEDBACK_ID , FEEDBACK.STMT_ID , FEEDBACK.STMT_PERD_ID , FEEDBACK.PERD_RUN_ID , FEEDBACK.QUESTION1_REQUIRED_FLAG , FEEDBACK.QUESTION2_REQUIRED_FLAG , FEEDBACK.QUESTION3_REQUIRED_FLAG , FEEDBACK.QUESTION4_REQUIRED_FLAG , FEEDBACK.QUESTION5_REQUIRED_FLAG , FEEDBACK_TL.LANGUAGE , FEEDBACK_TL.SOURCE_LANG , FEEDBACK_TL.RATING_INSTRUCTION , FEEDBACK_TL.QUESTION1 , FEEDBACK_TL.QUESTION2 , FEEDBACK_TL.QUESTION3 , FEEDBACK_TL.QUESTION4 , FEEDBACK_TL.QUESTION5 , FEEDBACK.REQUEST_ID , FEEDBACK.JOB_DEFINITION_NAME , FEEDBACK.JOB_DEFINITION_PACKAGE , FEEDBACK.CREATED_BY , FEEDBACK.CREATION_DATE , FEEDBACK.LAST_UPDATE_DATE , FEEDBACK.LAST_UPDATED_BY , FEEDBACK.LAST_UPDATE_LOGIN FROM CMP_TCS_STMT_FEEDBACK_B FEEDBACK, CMP_TCS_STMT_FEEDBACK_TL FEEDBACK_TL WHERE FEEDBACK.STMT_FEEDBACK_ID = FEEDBACK_TL.STMT_FEEDBACK_ID AND FEEDBACK_TL.LANGUAGE = USERENV('LANG')