1. Tables and Views for Project Management
  2. PJO_XCC_CTRL_BDGT_SEGMENTS_V

PJO_XCC_CTRL_BDGT_SEGMENTS_V

Details

  • Schema: FUSION

  • Object owner: PJO

  • Object type: VIEW

Columns

Name

CTRL_BDGT_SEGMENT_ID

PROJECT_ID

OBJECT_TYPE

OBJECT_ID

RBS_ELEMENT_ID

PROJECT_NUMBER

PROJECT_NAME

RESOURCE_ALIAS

RESOURCE_NAME

RESOURCE_PARENT_ID

CTRL_BUDGET_SEGMENT

Query

SQL_Statement

SELECT

A.CTRL_BDGT_SEGMENT_ID,

A.PROJECT_ID,

A.OBJECT_TYPE,

A.OBJECT_ID,

A.RBS_ELEMENT_ID,

A.PROJECT_NUMBER,

A.PROJECT_NAME,

A.RESOURCE_ALIAS,

A.RESOURCE_NAME,

A.RESOURCE_PARENT_ID,

A.CTRL_BUDGET_SEGMENT

from

PJO_XCC_CTRL_BDGT_SEGMENTS A,

pjf_rbs_elements rbs

WHERE segment_type = 'RESOURCE'

and A.UNIQUE_FLAG = 'Y'

and a.rbs_element_id = rbs.rbs_element_id

and rbs.rbs_level = 2