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 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, decode(a.task_id, - 99, 'Unbudgeted Task', ( SELECT petl.name FROM pjf_proj_elements_tl petl WHERE peb.proj_element_id = petl.proj_element_id AND peb.project_id = petl.project_id AND petl.language = userenv('LANG') )) TASK_NAME, A.TASK_TOP_ELEM_ID, A.CTRL_BUDGET_SEGMENT FROM pjo_xcc_ctrl_bdgt_segments a, pjf_proj_elements_b peb WHERE a.segment_type = 'TASK' AND a.unique_flag = 'Y' AND a.task_id = peb.proj_element_id (+) AND ( peb.leaf_node_flag = 'Y' OR a.task_id = - 99 )