機械翻訳について

POZ_BI_APPR_USER_COMMENTS_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: POZ

• オブジェクト・タイプ: VIEW

列

名前
AMX_IDENTIFICATION_KEY ACTION_SEQ_NUM PERFORMER_ID LATEST_COMMENT

問合せ

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および POZ_APPROVAL_HISTORY.SEQUENCE_NUM = POZ_APPROVAL_USER_COMMENTS.ACTION_SEQ_NUM AND POZ_APPROVAL_HISTORY. PERFORMER_ID = POZ_APPROVAL_USER_COMMENTS.PERFORMER_ID