PJO_XCC_CTRL_BDGT_TOP_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 PROJECT_NUMBER PROJECT_NAME TASK_NUMBER TASK_NAME TASK_TOP_ELEM_ID CTRL_BUDGET_SEGMENT

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.PROJECT_NUMBER, A.PROJECT_NAME, PEB.ELEMENT_NUMBER TASK_NUMBER, PETL.NAME TASK_NAME, A.TASK_TOP_ELEM_ID, A.CTRL_BUDGET_SEGMENT FROM pjf_proj_elements_b PEB, pjf_proj_elements_tl PETL, PJO_XCC_CTRL_BDGT_SEGMENTS A WHERE A.segment_type = 'TASK' and A.UNIQUE_FLAG = 'Y' and PEB.denorm_wbs_level <= 1 AND A.TASK_ID = PEB.PROJ_ELEMENT_ID AND PEB.PROJ_ELEMENT_ID = PETL.PROJ_ELEMENT_ID AND PEB.PROJECT_ID = PETL.PROJECT_ID AND PETL.LANGUAGE = USERENV('LANG')