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 SEGMENT_TYPE TASK_ID RBS_ELEMENT_ID PROJECT_NUMBER PROJECT_NAME TASK_NUMBER TASK_NAME TASK_NAME1 RESOURCE_ALIAS RESOURCE_NAME TASK_TOP_ELEM_ID RESOURCE_PARENT_ID CTRL_BUDGET_SEGMENT UNIQUE_FLAG CONTRACT_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER CREATED_BY DISPLAY_SEQUENCE TREE_FLAG SAVED_FLAG FLEX_VALUE_ATTRIBUTE1 FLEX_VALUE_ATTRIBUTE2 FLEX_VALUE_ATTRIBUTE3 FLEX_VALUE_ATTRIBUTE4 FLEX_VALUE_ATTRIBUTE5 FLEX_VALUE_ATTRIBUTE6 FLEX_VALUE_ATTRIBUTE7 FLEX_VALUE_ATTRIBUTE8 FLEX_VALUE_ATTRIBUTE9 FLEX_VALUE_ATTRIBUTE10 FLEX_VALUE_ATTRIBUTE11 FLEX_VALUE_ATTRIBUTE12 FLEX_VALUE_ATTRIBUTE13 FLEX_VALUE_ATTRIBUTE14 FLEX_VALUE_ATTRIBUTE15 FLEX_VALUE_ATTRIBUTE16 FLEX_VALUE_ATTRIBUTE17 FLEX_VALUE_ATTRIBUTE18 FLEX_VALUE_ATTRIBUTE19 FLEX_VALUE_ATTRIBUTE20 SUMMARY_FLAG

Query

SQL_Statement

SELECT A.CTRL_BDGT_SEGMENT_ID, A.PROJECT_ID, A.OBJECT_TYPE, A.OBJECT_ID, A.SEGMENT_TYPE, A.TASK_ID, A.RBS_ELEMENT_ID, A.PROJECT_NUMBER, A.PROJECT_NAME, A.TASK_NUMBER, A.TASK_NAME, SUBSTR(A.TASK_NAME,1,240) TASK_NAME1, A.RESOURCE_ALIAS, A.RESOURCE_NAME, A.TASK_TOP_ELEM_ID, A.RESOURCE_PARENT_ID, A.CTRL_BUDGET_SEGMENT, A.UNIQUE_FLAG, A.CONTRACT_NUMBER, A.LAST_UPDATE_DATE, A.LAST_UPDATED_BY, A.CREATION_DATE, A.LAST_UPDATE_LOGIN, A.OBJECT_VERSION_NUMBER, A.CREATED_BY, A.DISPLAY_SEQUENCE, A.TREE_FLAG, A.SAVED_FLAG, 'N' FLEX_VALUE_ATTRIBUTE1, 'N' FLEX_VALUE_ATTRIBUTE2, NULL FLEX_VALUE_ATTRIBUTE3, NULL FLEX_VALUE_ATTRIBUTE4, NULL FLEX_VALUE_ATTRIBUTE5, NULL FLEX_VALUE_ATTRIBUTE6, NULL FLEX_VALUE_ATTRIBUTE7, NULL FLEX_VALUE_ATTRIBUTE8, NULL FLEX_VALUE_ATTRIBUTE9, NULL FLEX_VALUE_ATTRIBUTE10, NULL FLEX_VALUE_ATTRIBUTE11, NULL FLEX_VALUE_ATTRIBUTE12, NULL FLEX_VALUE_ATTRIBUTE13, NULL FLEX_VALUE_ATTRIBUTE14, NULL FLEX_VALUE_ATTRIBUTE15, NULL FLEX_VALUE_ATTRIBUTE16, NULL FLEX_VALUE_ATTRIBUTE17, NULL FLEX_VALUE_ATTRIBUTE18, NULL FLEX_VALUE_ATTRIBUTE19, NULL FLEX_VALUE_ATTRIBUTE20, DECODE((SELECT 1 FROM PJF_RBS_ELEMENTS PRE WHERE PRE.LEAF_NODE_FLAG = 'N' AND PRE.RBS_ELEMENT_ID = A.RBS_ELEMENT_ID),1,'Y','N') SUMMARY_FLAG 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