PJB_CONTRACT_EVENTS_VL

Details

• Schema: FUSION

• Object owner: PJB

• Object type: VIEW

Columns

Name
CONTRACT_EVENT_ID MAJOR_VERSION VERSION_TYPE CONTRACT_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CONTRACT_LINE_ID PROJ_ELEMENT_ID NAME PROJECT_ID PARENT_PROJ_ELEMENT_ID TRNS_CURRENCY_CODE BILL_TRNS_AMOUNT EST_COMPLETION_DATE EVENT_TYPE_ID EVENT_DESC EXCEPTION_STATUS_CODE EVENT_CLASSIFICATION_CODE EXTERNAL_KEY1 EXTERNAL_KEY2

Query

SQL_Statement

SELECT PCEB.CONTRACT_EVENT_ID, PCEB.MAJOR_VERSION, PCEB.VERSION_TYPE, PCEB.CONTRACT_ID, PCEB.OBJECT_VERSION_NUMBER, PCEB.CREATED_BY, PCEB.CREATION_DATE, PCEB.LAST_UPDATED_BY, PCEB.LAST_UPDATE_DATE, PCEB.LAST_UPDATE_LOGIN, PCEB.CONTRACT_LINE_ID, PCEB.PROJ_ELEMENT_ID, PCETL.NAME, PCEB.PROJECT_ID, PCEB.PARENT_PROJ_ELEMENT_ID, PCEB.TRNS_CURRENCY_CODE, PCEB.BILL_TRNS_AMOUNT, PCEB.EST_COMPLETION_DATE, PCEB.EVENT_TYPE_ID, PCEB.EVENT_DESC, PCEB.EXCEPTION_STATUS_CODE, PCEB.EVENT_CLASSIFICATION_CODE, PCEB.EXTERNAL_KEY1, PCEB.EXTERNAL_KEY2 FROM PJB_CONTRACT_EVENTS_B PCEB, PJB_CONTRACT_EVENTS_TL PCETL WHERE PCEB.CONTRACT_EVENT_ID = PCETL.CONTRACT_EVENT_ID AND PCEB.MAJOR_VERSION = PCETL.MAJOR_VERSION AND LANGUAGE = USERENV('LANG')