POZ_BI_APPR_USER_COMMENTS_V
Details
-
Schema: FUSION
-
Object owner: POZ
-
Object type: VIEW
Columns
Name |
---|
AMX_IDENTIFICATION_KEY ACTION_SEQ_NUM PERFORMER_ID LATEST_COMMENT |
Query
SQL_Statement |
---|
SELECT DISTINCT POZ_APPROVAL_USER_COMMENTS.AMX_IDENTIFICATION_KEY, POZ_APPROVAL_USER_COMMENTS.ACTION_SEQ_NUM, POZ_APPROVAL_USER_COMMENTS.PERFORMER_ID, FIRST_VALUE (POZ_APPROVAL_USER_COMMENTS.APPROVAL_COMMENT) OVER (PARTITION BY POZ_APPROVAL_USER_COMMENTS.AMX_IDENTIFICATION_KEY, POZ_APPROVAL_USER_COMMENTS.PERFORMER_ID, POZ_APPROVAL_USER_COMMENTS.ACTION_SEQ_NUM ORDER BY POZ_APPROVAL_USER_COMMENTS.COMMENT_DATE DESC) AS LATEST_COMMENT FROM POZ_APPROVAL_HISTORY, POZ_APPROVAL_USER_COMMENTS WHERE POZ_APPROVAL_HISTORY.AMX_IDENTIFICATION_KEY = POZ_APPROVAL_USER_COMMENTS. AMX_IDENTIFICATION_KEY AND POZ_APPROVAL_HISTORY.SEQUENCE_NUM = POZ_APPROVAL_USER_COMMENTS.ACTION_SEQ_NUM AND POZ_APPROVAL_HISTORY. PERFORMER_ID = POZ_APPROVAL_USER_COMMENTS.PERFORMER_ID |