View HLPDTEST.STATEGPS.T_WEEKLY_OPEN_CLOSED_TASKS_V | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Apr 12 01:05 IST 2021 |
View Definition:
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
Possibly Referenced Tables/Views:
![]() ![]() |