1. Tables and Views for Project Management
  2. PJE_CHANGE_IMPACT_ELEM_DTLS_VL

PJE_CHANGE_IMPACT_ELEM_DTLS_VL

Details

  • Schema: FUSION

  • Object owner: PJE

  • Object type: VIEW

Columns

Name

IMPACT_ELEM_DETAILS_ID

CHANGE_IMPACT_ID

CHANGE_DOCUMENT_ID

PROJECT_ID

ELEMENT_ACTION

PROJ_ELEMENT_ID

ELEMENT_NUMBER

PARENT_PROJ_ELEMENT_ID

MILESTONE_FLAG

START_DATE

FINISH_DATE

ELEMENT_NAME

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

B.IMPACT_ELEM_DETAILS_ID,

B.CHANGE_IMPACT_ID,

B.CHANGE_DOCUMENT_ID,

B.PROJECT_ID,

B.ELEMENT_ACTION,

B.PROJ_ELEMENT_ID,

B.ELEMENT_NUMBER,

B.PARENT_PROJ_ELEMENT_ID,

B.MILESTONE_FLAG,

B.START_DATE,

B.FINISH_DATE,

TL.ELEMENT_NAME,

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_IMPACT_ELEM_DTLS_B B, PJE_CHANGE_IMPACT_ELEM_DTLS_TL TL

WHERE

B.IMPACT_ELEM_DETAILS_ID = TL.IMPACT_ELEM_DETAILS_ID

AND TL.LANGUAGE = USERENV('LANG')