PJC_ALLOC_SRC_TASKS_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name
PROJECT_ID TASK_ID TASK_NUMBER TASK_NAME SERVICE_TYPE_CODE CARRYING_OUT_ORGANIZATION_ID

Query

SQL_Statement
select PROJECT_ID,TASK_ID,TASK_NUMBER,TASK_NAME,service_type_code SERVICE_TYPE_CODE,carrying_out_organization_id CARRYING_OUT_ORGANIZATION_ID from pjf_tasks_v where (task_id = top_task_id or leaf_node_flag = 'Y')