PJS_PPC_FEEDBACK_VL

Details

• Schema: FUSION

• Object owner: PJS

• Object type: VIEW

Columns

Name
FEEDBACK_ID REPORT_ID REPORT_OBJECT_ID PERSON_ID EMOTION_CODE COMMENT_TEXT CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER ADDL_ATTRIBUTE1 ADDL_ATTRIBUTE2 ADDL_ATTRIBUTE3 ADDL_ATTRIBUTE4 ADDL_ATTRIBUTE5

Query

SQL_Statement

SELECT PJS_PPC_FEEDBACK_B.FEEDBACK_ID, PJS_PPC_FEEDBACK_B.REPORT_ID, PJS_PPC_FEEDBACK_B.REPORT_OBJECT_ID, PJS_PPC_FEEDBACK_B.PERSON_ID, PJS_PPC_FEEDBACK_TL.EMOTION_CODE, PJS_PPC_FEEDBACK_TL.COMMENT_TEXT, PJS_PPC_FEEDBACK_B.CREATED_BY, PJS_PPC_FEEDBACK_B.CREATION_DATE, PJS_PPC_FEEDBACK_B.LAST_UPDATED_BY, PJS_PPC_FEEDBACK_B.LAST_UPDATE_DATE, PJS_PPC_FEEDBACK_B.LAST_UPDATE_LOGIN, PJS_PPC_FEEDBACK_B.OBJECT_VERSION_NUMBER, PJS_PPC_FEEDBACK_B.ADDL_ATTRIBUTE1, PJS_PPC_FEEDBACK_B.ADDL_ATTRIBUTE2, PJS_PPC_FEEDBACK_B.ADDL_ATTRIBUTE3, PJS_PPC_FEEDBACK_B.ADDL_ATTRIBUTE4, PJS_PPC_FEEDBACK_B.ADDL_ATTRIBUTE5 FROM PJS_PPC_FEEDBACK_B, PJS_PPC_FEEDBACK_TL WHERE PJS_PPC_FEEDBACK_B.FEEDBACK_ID = PJS_PPC_FEEDBACK_TL.FEEDBACK_ID AND PJS_PPC_FEEDBACK_TL.LANGUAGE = USERENV('LANG')