PJE_CHANGE_PARTICIPANTS

Details

Schema: FUSION
Object owner: PJE
Object type: VIEW

Columns

Name
PARTICIPANT_ID RESOURCE_ID CHANGE_DOCUMENT_ID ASSESSMENT_FLAG ASSESSMENT_STATUS REVIEW_FLAG REVIEW_STATUS APPROVE_FLAG APPROVE_STATUS IMPLEMENTATION_FLAG IMPLEMENTATION_STATUS CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER ASSESSMENT_COMMENTS REVIEW_COMMENTS APPROVE_COMMENTS IMPLEMENTATION_COMMENTS REJECT_TYPE REJECT_DATE

Name

PARTICIPANT_ID

RESOURCE_ID

CHANGE_DOCUMENT_ID

ASSESSMENT_FLAG

ASSESSMENT_STATUS

REVIEW_FLAG

REVIEW_STATUS

APPROVE_FLAG

APPROVE_STATUS

IMPLEMENTATION_FLAG

IMPLEMENTATION_STATUS

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

ASSESSMENT_COMMENTS

REVIEW_COMMENTS

APPROVE_COMMENTS

IMPLEMENTATION_COMMENTS

REJECT_TYPE

REJECT_DATE

Query

SQL_Statement
SELECT PJE_CHANGE_PARTICIPANTS_B.PARTICIPANT_ID, PJE_CHANGE_PARTICIPANTS_B.RESOURCE_ID, PJE_CHANGE_PARTICIPANTS_B.CHANGE_DOCUMENT_ID, PJE_CHANGE_PARTICIPANTS_B.ASSESSMENT_FLAG, PJE_CHANGE_PARTICIPANTS_B.ASSESSMENT_STATUS, PJE_CHANGE_PARTICIPANTS_B.REVIEW_FLAG, PJE_CHANGE_PARTICIPANTS_B.REVIEW_STATUS, PJE_CHANGE_PARTICIPANTS_B.APPROVE_FLAG, PJE_CHANGE_PARTICIPANTS_B.APPROVE_STATUS, PJE_CHANGE_PARTICIPANTS_B.IMPLEMENTATION_FLAG, PJE_CHANGE_PARTICIPANTS_B.IMPLEMENTATION_STATUS, PJE_CHANGE_PARTICIPANTS_B.CREATED_BY, PJE_CHANGE_PARTICIPANTS_B.CREATION_DATE, PJE_CHANGE_PARTICIPANTS_B.LAST_UPDATED_BY, PJE_CHANGE_PARTICIPANTS_B.LAST_UPDATE_DATE, PJE_CHANGE_PARTICIPANTS_B.LAST_UPDATE_LOGIN, PJE_CHANGE_PARTICIPANTS_B.OBJECT_VERSION_NUMBER, PJE_CHANGE_PARTICIPANTS_TL.ASSESSMENT_COMMENTS, PJE_CHANGE_PARTICIPANTS_TL.REVIEW_COMMENTS, PJE_CHANGE_PARTICIPANTS_TL.APPROVE_COMMENTS, PJE_CHANGE_PARTICIPANTS_TL.IMPLEMENTATION_COMMENTS, PJE_CHANGE_PARTICIPANTS_B.REJECT_TYPE, PJE_CHANGE_PARTICIPANTS_B.REJECT_DATE FROM PJE_CHANGE_PARTICIPANTS_B, PJE_CHANGE_PARTICIPANTS_TL WHERE PJE_CHANGE_PARTICIPANTS_B.PARTICIPANT_ID = PJE_CHANGE_PARTICIPANTS_TL.PARTICIPANT_ID AND PJE_CHANGE_PARTICIPANTS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

PJE_CHANGE_PARTICIPANTS_B.PARTICIPANT_ID,

PJE_CHANGE_PARTICIPANTS_B.RESOURCE_ID,

PJE_CHANGE_PARTICIPANTS_B.CHANGE_DOCUMENT_ID,

PJE_CHANGE_PARTICIPANTS_B.ASSESSMENT_FLAG,

PJE_CHANGE_PARTICIPANTS_B.ASSESSMENT_STATUS,

PJE_CHANGE_PARTICIPANTS_B.REVIEW_FLAG,

PJE_CHANGE_PARTICIPANTS_B.REVIEW_STATUS,

PJE_CHANGE_PARTICIPANTS_B.APPROVE_FLAG,

PJE_CHANGE_PARTICIPANTS_B.APPROVE_STATUS,

PJE_CHANGE_PARTICIPANTS_B.IMPLEMENTATION_FLAG,

PJE_CHANGE_PARTICIPANTS_B.IMPLEMENTATION_STATUS,

PJE_CHANGE_PARTICIPANTS_B.CREATED_BY,

PJE_CHANGE_PARTICIPANTS_B.CREATION_DATE,

PJE_CHANGE_PARTICIPANTS_B.LAST_UPDATED_BY,

PJE_CHANGE_PARTICIPANTS_B.LAST_UPDATE_DATE,

PJE_CHANGE_PARTICIPANTS_B.LAST_UPDATE_LOGIN,

PJE_CHANGE_PARTICIPANTS_B.OBJECT_VERSION_NUMBER,

PJE_CHANGE_PARTICIPANTS_TL.ASSESSMENT_COMMENTS,

PJE_CHANGE_PARTICIPANTS_TL.REVIEW_COMMENTS,

PJE_CHANGE_PARTICIPANTS_TL.APPROVE_COMMENTS,

PJE_CHANGE_PARTICIPANTS_TL.IMPLEMENTATION_COMMENTS,

PJE_CHANGE_PARTICIPANTS_B.REJECT_TYPE,

PJE_CHANGE_PARTICIPANTS_B.REJECT_DATE

FROM

PJE_CHANGE_PARTICIPANTS_B,

PJE_CHANGE_PARTICIPANTS_TL

WHERE

PJE_CHANGE_PARTICIPANTS_B.PARTICIPANT_ID = PJE_CHANGE_PARTICIPANTS_TL.PARTICIPANT_ID AND PJE_CHANGE_PARTICIPANTS_TL.LANGUAGE = USERENV('LANG')