PJF_PROJ_ELEM_DENORM

Details

Schema: FUSION
Object owner: PJF
Object type: VIEW

Columns

Name
DISPLAY_SEQUENCE PROJ_ELEMENT_ID PROJECT_ID OBJECT_TYPE ELEMENT_NUMBER DENORM_TOP_ELEMENT_ID DENORM_WBS_LEVEL DENORM_PARENT_ELEMENT_ID SERVICE_TYPE_CODE CHARGEABLE_FLAG BILLABLE_FLAG START_DATE COMPLETION_DATE CLIN_ELEMENT_ID NAME DESCRIPTION CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY PM_SOURCE_CODE PM_SOURCE_REFERENCE MANAGER_PERSON_ID CARRYING_OUT_ORGANIZATION_ID LAST_UPDATE_LOGIN PARENT_STRUCTURE_ID OBJECT_VERSION_NUMBER STRUCTURE_TYPE LEAF_NODE_FLAG CREATED_FROM_SOURCE_ID IC_CLIN_ELEMENT_ID CRITICAL_FLAG MILESTONE_FLAG

Name

DISPLAY_SEQUENCE

PROJ_ELEMENT_ID

PROJECT_ID

OBJECT_TYPE

ELEMENT_NUMBER

DENORM_TOP_ELEMENT_ID

DENORM_WBS_LEVEL

DENORM_PARENT_ELEMENT_ID

SERVICE_TYPE_CODE

CHARGEABLE_FLAG

BILLABLE_FLAG

START_DATE

COMPLETION_DATE

CLIN_ELEMENT_ID

NAME

DESCRIPTION

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

PM_SOURCE_CODE

PM_SOURCE_REFERENCE

MANAGER_PERSON_ID

CARRYING_OUT_ORGANIZATION_ID

LAST_UPDATE_LOGIN

PARENT_STRUCTURE_ID

OBJECT_VERSION_NUMBER

STRUCTURE_TYPE

LEAF_NODE_FLAG

CREATED_FROM_SOURCE_ID

IC_CLIN_ELEMENT_ID

CRITICAL_FLAG

MILESTONE_FLAG

Query

SQL_Statement
(SELECT pjfProjElementVersions.display_sequence, PjfProjectElements.PROJ_ELEMENT_ID, PjfProjectElements.PROJECT_ID , PjfProjectElements.OBJECT_TYPE , PjfProjectElements.ELEMENT_NUMBER , PjfProjectElements.DENORM_TOP_ELEMENT_ID , PjfProjectElements.DENORM_WBS_LEVEL , PjfProjectElements.DENORM_PARENT_ELEMENT_ID , PjfProjectElements.SERVICE_TYPE_CODE , PjfProjectElements.CHARGEABLE_FLAG , PjfProjectElements.BILLABLE_FLAG , PjfProjectElements.START_DATE , PjfProjectElements.COMPLETION_DATE , PjfProjectElements.CLIN_ELEMENT_ID , PjfProjectElements.NAME , PjfProjectElements.DESCRIPTION , PjfProjectElements.CREATION_DATE , PjfProjectElements.CREATED_BY , PjfProjectElements.LAST_UPDATE_DATE , PjfProjectElements.LAST_UPDATED_BY , PjfProjectElements.PM_SOURCE_CODE , PjfProjectElements.PM_SOURCE_REFERENCE , PjfProjectElements.MANAGER_PERSON_ID , PjfProjectElements.CARRYING_OUT_ORGANIZATION_ID , PjfProjectElements.LAST_UPDATE_LOGIN , PjfProjectElements.PARENT_STRUCTURE_ID , PjfProjectElements.OBJECT_VERSION_NUMBER , PjfProjectElements.STRUCTURE_TYPE , NVL(PjfProjectElements.LEAF_NODE_FLAG,'N') LEAF_NODE_FLAG , PjfProjectElements.CREATED_FROM_SOURCE_ID , PjfProjectElements.IC_CLIN_ELEMENT_ID , PjfProjectElements.CRITICAL_FLAG , PjfProjectElements.MILESTONE_FLAG FROM PJF_PROJ_ELEMENTS_VL PjfProjectElements, PJF_PROJ_ELEMENT_VERSION pjfProjElementVersions WHERE PjfProjectElements.proj_element_id = pjfProjElementVersions.proj_element_id AND PjfProjectElements.project_id = pjfProjElementVersions.project_id AND PjfProjectElements.element_type = 'FINANCIAL' UNION ALL SELECT pjfProjElementVersions.display_sequence, PjfProjectElements.PROJ_ELEMENT_ID, PjfProjectElements.PROJECT_ID , PjfProjectElements.OBJECT_TYPE , PjfProjectElements.ELEMENT_NUMBER , PjfProjectElements.DENORM_TOP_ELEMENT_ID , PjfProjectElements.DENORM_WBS_LEVEL + 1 , PjfProjectElements.PROJ_ELEMENT_ID , PjfProjectElements.SERVICE_TYPE_CODE , PjfProjectElements.CHARGEABLE_FLAG , PjfProjectElements.BILLABLE_FLAG , PjfProjectElements.START_DATE , PjfProjectElements.COMPLETION_DATE , PjfProjectElements.CLIN_ELEMENT_ID , PjfProjectElements.NAME , PjfProjectElements.DESCRIPTION , PjfProjectElements.CREATION_DATE , PjfProjectElements.CREATED_BY , PjfProjectElements.LAST_UPDATE_DATE , PjfProjectElements.LAST_UPDATED_BY , PjfProjectElements.PM_SOURCE_CODE , PjfProjectElements.PM_SOURCE_REFERENCE , PjfProjectElements.MANAGER_PERSON_ID , PjfProjectElements.CARRYING_OUT_ORGANIZATION_ID , PjfProjectElements.LAST_UPDATE_LOGIN , PjfProjectElements.PARENT_STRUCTURE_ID , PjfProjectElements.OBJECT_VERSION_NUMBER , PjfProjectElements.STRUCTURE_TYPE , 'Y' , PjfProjectElements.CREATED_FROM_SOURCE_ID , PjfProjectElements.IC_CLIN_ELEMENT_ID , PjfProjectElements.CRITICAL_FLAG , PjfProjectElements.MILESTONE_FLAG FROM PJF_PROJ_ELEMENTS_VL PjfProjectElements , PJF_PROJ_ELEMENT_VERSION pjfProjElementVersions WHERE NVL(PjfProjectElements.LEAF_NODE_FLAG,'N') = 'N' AND PjfProjectElements.proj_element_id = pjfProjElementVersions.proj_element_id AND PjfProjectElements.project_id = pjfProjElementVersions.project_id AND PjfProjectElements.element_type = 'FINANCIAL' )

SQL_Statement

(SELECT pjfProjElementVersions.display_sequence,

PjfProjectElements.PROJ_ELEMENT_ID,

PjfProjectElements.PROJECT_ID ,

PjfProjectElements.OBJECT_TYPE ,

PjfProjectElements.ELEMENT_NUMBER ,

PjfProjectElements.DENORM_TOP_ELEMENT_ID ,

PjfProjectElements.DENORM_WBS_LEVEL ,

PjfProjectElements.DENORM_PARENT_ELEMENT_ID ,

PjfProjectElements.SERVICE_TYPE_CODE ,

PjfProjectElements.CHARGEABLE_FLAG ,

PjfProjectElements.BILLABLE_FLAG ,

PjfProjectElements.START_DATE ,

PjfProjectElements.COMPLETION_DATE ,

PjfProjectElements.CLIN_ELEMENT_ID ,

PjfProjectElements.NAME ,

PjfProjectElements.DESCRIPTION ,

PjfProjectElements.CREATION_DATE ,

PjfProjectElements.CREATED_BY ,

PjfProjectElements.LAST_UPDATE_DATE ,

PjfProjectElements.LAST_UPDATED_BY ,

PjfProjectElements.PM_SOURCE_CODE ,

PjfProjectElements.PM_SOURCE_REFERENCE ,

PjfProjectElements.MANAGER_PERSON_ID ,

PjfProjectElements.CARRYING_OUT_ORGANIZATION_ID ,

PjfProjectElements.LAST_UPDATE_LOGIN ,

PjfProjectElements.PARENT_STRUCTURE_ID ,

PjfProjectElements.OBJECT_VERSION_NUMBER ,

PjfProjectElements.STRUCTURE_TYPE ,

NVL(PjfProjectElements.LEAF_NODE_FLAG,'N') LEAF_NODE_FLAG ,

PjfProjectElements.CREATED_FROM_SOURCE_ID ,

PjfProjectElements.IC_CLIN_ELEMENT_ID ,

PjfProjectElements.CRITICAL_FLAG ,

PjfProjectElements.MILESTONE_FLAG

FROM PJF_PROJ_ELEMENTS_VL PjfProjectElements, PJF_PROJ_ELEMENT_VERSION pjfProjElementVersions

WHERE PjfProjectElements.proj_element_id = pjfProjElementVersions.proj_element_id

AND PjfProjectElements.project_id = pjfProjElementVersions.project_id

AND PjfProjectElements.element_type = 'FINANCIAL'

UNION ALL

SELECT pjfProjElementVersions.display_sequence, PjfProjectElements.PROJ_ELEMENT_ID,