1. Tables and Views for Project Management
  2. PJO_RESOURCE_CF_VL

PJO_RESOURCE_CF_VL

Details

  • Schema: FUSION

  • Object owner: PJO

  • Object type: VIEW

Columns

Name

TREE_STRUCTURE_CODE

TREE_CODE

TREE_VERSION_ID

CF_TREE_NODE_ID

DEP0_DATA_SOURCE_ID

DEP0_PK1_VALUE

DEP0_PK2_VALUE

DEP1_PK1_VALUE

DEP1_PK2_VALUE

DEP2_PK1_VALUE

DEP2_PK2_VALUE

DEP3_PK1_VALUE

DEP3_PK2_VALUE

Query

SQL_Statement

select 'PJF_RESOURCE_TREE' TREE_STRUCTURE_CODE ,

ppv.project_id TREE_CODE,

'DB2B609B14CB48E0E0439D40B00AF29E' TREE_VERSION_ID ,

'DB2B5D1EF1A44817E0439D40B00A14DA' CF_TREE_NODE_ID ,

'7780CC533E9C302EE040449817F04682' DEP0_DATA_SOURCE_ID,

pre.rbs_version_id DEP0_PK1_VALUE,

decode(pre.rbs_level,4,pre.rbs_element_id,decode(pre.rbs_level,3,pre.rbs_element_id,decode(pre.rbs_level,2,pre.rbs_element_id,decode(pre.rbs_level,1,pre.rbs_element_id,null)))) DEP0_PK2_VALUE,

pre.rbs_version_id DEP1_PK1_VALUE,

decode(pre.rbs_level,3,pre.rbs_element_id,

decode(decode(pre.rbs_level,4,pre.parent_element_id,null)

,null,decode(pre.rbs_level,2,pre.rbs_element_id,decode(pre.rbs_level,1,pre.rbs_element_id,null)),decode(pre.rbs_level,4,pre.parent_element_id,null))) DEP1_PK2_VALUE,

pre.rbs_version_id DEP2_PK1_VALUE,

decode(decode(decode(pre.rbs_level,2,pre.rbs_element_id,null),null, (select parent_element_id from pjf_rbs_elements where rbs_element_id =decode(pre.rbs_level,3,pre.rbs_element_id,

decode(decode(pre.rbs_level,4,pre.parent_element_id,null)

,null,

decode(pre.rbs_level,2,pre.rbs_element_id,decode(pre.rbs_level,1,pre.rbs_element_id,null)),decode(pre.rbs_level,4,pre.parent_element_id,null))) ),decode(pre.rbs_level,2,pre.rbs_element_id,null)),null,

(select rbs_element_id from pjf_rbs_elements where rbs_level = 1 and rbs_element_id is not null and rbs_version_id = pre.rbs_version_id ),decode(decode(pre.rbs_level,2,pre.rbs_element_id,null),null, (select parent_element_id from pjf_rbs_elements where rbs_element_id =decode(pre.rbs_level,3,pre.rbs_element_id,

decode(decode(pre.rbs_level,4,pre.parent_element_id,null)

,null,

decode(pre.rbs_level,2,pre.rbs_element_id,decode(pre.rbs_level,1,pre.rbs_element_id,null)),decode(pre.rbs_level,4,pre.parent_element_id,null))) ),decode(pre.rbs_level,2,pre.rbs_element_id,null))) DEP2_PK2_VALUE,

pre.rbs_version_id DEP3_PK1_VALUE,

(select rbs_element_id from pjf_rbs_elements where rbs_level = 1 and rbs_element_id is not null and rbs_version_id = pre.rbs_version_id ) DEP3_PK2_VALUE

from

pjf_rbs_elements pre,

pjf_rbs_prj_assignments prpa,

pjf_projects_all_vl ppv

where

ppv.project_id = prpa.project_id

and prpa.primary_planning_rbs_flag = 'Y'

and prpa.rbs_version_id = pre.rbs_version_id