PJO_XCC_CTRL_BDGT_LOW_TASK_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 DESCRIPTION

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, PT.ELEMENT_NUMBER TASK_NUMBER, PT.NAME TASK_NAME, SUBSTR(PT.NAME,1,240) TASK_NAME1, (SELECT ALIAS FROM PJF_RBS_ELEMENTS_VL WHERE RBS_ELEMENT_ID=A.RBS_ELEMENT_ID) 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_PROJ_ELEMENTS_VL PPV WHERE PPV.LEAF_NODE_FLAG = 'N' AND PPV.PROJ_ELEMENT_ID = A.TASK_ID),1,'Y','N' ) SUMMARY_FLAG, PT.DESCRIPTION DESCRIPTION FROM pjf_proj_elements_vl PT, PJO_XCC_CTRL_BDGT_SEGMENTS A WHERE A.segment_type = 'TASK' and A.UNIQUE_FLAG = 'Y' and pt.leaf_node_flag = 'Y' AND A.TASK_ID = PT.PROJ_ELEMENT_ID union SELECT A.CTRL_BDGT_SEGMENT_ID, A.PROJECT_ID, A.OBJECT_TYPE, A.OBJECT_ID, A.SEGMENT_TYPE, A.task_id , null, A.PROJECT_NUMBER, A.PROJECT_NAME, 'Unbudgeted Task' TASK_NUMBER, 'Unbudgeted Task' TASK_NAME, 'Unbudgeted Task' 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, 'N', LOOKUP.MEANING DESCRIPTION from PJO_XCC_CTRL_BDGT_SEGMENTS A,PJO_LOOKUPS LOOKUP WHERE A.task_id = -99 and A.SEGMENT_TYPE='TASK' AND LOOKUP.LOOKUP_CODE =DECODE(A.task_id,-99,'UNBUDGETED_TASK')