select a.application_name PROJECT, wt.workflow_type_name, ws.state_name,pt.user_name, next_day(trunc(gi.created_date)-7,'Monday') TASK_DATE, decode(gi.instance_present,0,'CLOSED') STATUS, gi.instance_id from t_gps_instances gi, t_project_task pt, t_gps_applications a, t_gps_workflow_types wt, t_gps_workflow_states ws where gi.workflow_type_id = wt.workflow_type_id and a.application_id = gi.application_id and a.visible_flag = 'true' and pt.instance_id = gi.instance_id and pt.state_id = gi.current_state_id and pt.state_id = ws.state_id and gi.active = 1 and decode(gi.instance_present,0,'CLOSED') is not null union select a.application_name PROJECT, wt.workflow_type_name, ws.state_name,pt.user_name, next_day(trunc(gi.created_date)-7,'Monday') TASK_DATE, 'OPEN' STATUS, gi.instance_id from t_gps_instances gi, t_project_task pt, t_gps_applications a, t_gps_workflow_types wt, t_gps_workflow_states ws where gi.workflow_type_id = wt.workflow_type_id and a.application_id = gi.application_id and a.visible_flag = 'true' and pt.instance_id = gi.instance_id and gi.active = 1 and pt.state_id = gi.current_state_id and pt.state_id = ws.state_id