PJE_CHANGE_REQUESTS_VL

Details

• Schema: FUSION

• Object owner: PJE

• Object type: VIEW

Columns

Name
CHANGE_REQUEST_ID CHANGE_REQUEST_NUMBER NAME DESCRIPTION OWNER_PERSON_ID PRIORITY_CODE STATUS_CODE CREATED_BY_PERSON_ID REASON_CODE PROJECT_ID CANCELLATION_TYPE_CODE REJECTION_TYPE_CODE APPROVER_PERSON_ID APPROVAL_DATE JUSTIFICATION IMPACT_IF_NOT_IMPL COMMENTS OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.CHANGE_REQUEST_ID, B.CHANGE_REQUEST_NUMBER, TL.NAME, TL.DESCRIPTION, B.OWNER_PERSON_ID, B.PRIORITY_CODE, B.STATUS_CODE, B.CREATED_BY_PERSON_ID, B.REASON_CODE, B.PROJECT_ID, B.CANCELLATION_TYPE_CODE, B.REJECTION_TYPE_CODE, B.APPROVER_PERSON_ID, B.APPROVAL_DATE, TL.JUSTIFICATION, TL.IMPACT_IF_NOT_IMPL, TL.COMMENTS, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM PJE_CHANGE_REQUESTS_B B, PJE_CHANGE_REQUESTS_TL TL WHERE B.CHANGE_REQUEST_ID= TL.CHANGE_REQUEST_ID AND TL.LANGUAGE = USERENV('LANG')