View HLPDTEST.STATEGPS.V_PEREGRINE_RESOURCE_LOAD Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
WEEK_START date 7  √  null
INSTANCE_ID number 22  √  null
T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Implied Constraint R
ISSUE_TITLE varchar2 4000  √  null
CONSULTANT varchar2 2000  √  null
PSC_USER varchar2 2000  √  null
START_DATE date 7  √  null
FINISH_DATE date 7  √  null
TIME_IN_DAYS number 22  √  null
TIME_IN_HOURS number 22  √  null
TASK_NAME varchar2 255  √  null

Analyzed at Sun Oct 18 01:05 IST 2020

View Definition:
select next_day(trunc(t1.start_date)-7,'Monday') WEEK_START,t1.instance_id, (select ip.IA_ISSUE_TITLE from v_instance_props ip where ip.INSTANCE_ID = t1.instance_id) ISSUE_TITLE, t1.user_name consultant, t2.user_name PSC_USER, trunc(t1.start_date) start_Date, trunc(t1.finish_date) finish_date, t1.duration time_in_days, t1.duration*8 time_in_hours , t1.TASK_NAME from ( select distinct pt.state_id, pt.start_date,pt.finish_date,pt.user_name, pt.duration , pt.instance_id, 'Observe Task' TASK_NAME from t_project_Task pt, t_gps_instances gi where pt.instance_id is not null and pt.state_id = 1201649 and (pt.duration > 0 or pt.duration is NULL) and (pt.daysremaining > 0 or pt.daysremaining is NULL) and pt.instance_id=gi.instance_id and gi.active=1 ) t1, ( select distinct pt.state_id, pt.start_date,pt.finish_date,pt.user_name, pt.duration , pt.instance_id, 'Observe Task' TASK_NAME from t_project_Task pt, t_gps_instances gi where pt.instance_id is not null and pt.state_id = 1201518 and (pt.duration > 0 or pt.duration is NULL) and (pt.daysremaining > 0 or pt.daysremaining is NULL) and gi.instance_id = pt.instance_id and gi.active = 1 ) t2 where t1.instance_id = t2.instance_id union all select distinct next_day(trunc(t1.start_date)-7,'Monday') WEEK_START,t1.instance_id, (select ip.IA_ISSUE_TITLE from v_instance_props ip where ip.INSTANCE_ID = t1.instance_id) ISSUE_TITLE, decode(t1.state_id,1201519,user_name,' ') consultant, decode(t1.state_id,1201520,user_name,' ') PSC_USER, trunc(t1.start_date) start_Date, trunc(t1.finish_date) finish_date, t1.duration time_in_days, t1.duration*8 time_in_hours, ws.state_name from t_project_Task t1, t_gps_workflow_states ws, t_gps_instances gi where t1.instance_id is not null and t1.state_id in (1201520,1201519) and t1.state_id = ws.state_id and (t1.duration > 0 or t1.duration is NULL) and (t1.daysremaining > 0 or t1.daysremaining is NULL) and gi.instance_id = t1.instance_id and gi.active=1
 
Possibly Referenced Tables/Views:


Close relationships: