7/25/2019 brcap

1/1

project_id = '36798'work_plan_id = ''41211'

WP_TASK_ACTUALS

SELECT * FROM pm_work_plans WP

inner join wp_tasks TKON TK.work_plan_id = WP.work_plan_id

inner join wp_task_schedule SCHDON SCHD.task_schedule_id = TK.task_schedule_id

inner join wp_task_actuals ACTON ACT.actuals_id = TK.

task_actuals_idinner join wp_task_info INFO

ON INFO.task_info_id =TK.task_info_id WHERE WP.entity_type = 'WORK_PLAN'

AND wp.project_id = '36798'AND SCHD.sched_start_date >= To_date(

'2016-03-01','YYYY-MM-DD HH24:MI:SS')

AND SCHD.sched_finish_date < To_date('2016-04-30','YYYY-MM-DD HH24:MI:SS')+ 1

AND INFO.TASK_TYPE_CODE = 'L'order by sequence_number