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