View HLPDTEST.STATEGPS.V_MONTHLY_PROJECT_STATISTICS 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
APPLICATION_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
MONTH_YEAR varchar2 8  √  null
TICKET_COUNT number 22  √  null
CLOSED_TICKET_COUNT number 22  √  null

Analyzed at Sun Oct 18 01:05 IST 2020

View Definition:
select nvl(a.application_id,b.application_id) application_id, nvl(a.month_year,b.month_year) MONTH_YEAR, nvl(a.TICKET_COUNT,0) TICKET_COUNT, nvl(b.CLOSED_TICKET_COUNT,0) CLOSED_TICKET_COUNT from ( SELECT to_char(I.creation_date,'MON-YYYY') MONTH_YEAR,count(distinct I.INSTANCE_ID) ticket_count, I.application_id FROM T_INSTANCES I, T_GPS_INSTANCES GI where I.INSTANCE_ID = GI.INSTANCE_ID AND GI.ACTIVE=1 group by to_char(I.creation_date,'MON-YYYY'), I.application_id ) a FULL OUTER JOIN ( SELECT to_char(GI.created_date, 'MON-YYYY') MONTH_YEAR, count(distinct I.INSTANCE_ID) closed_ticket_count, I.Application_Id FROM T_INSTANCES I, T_GPS_INSTANCES GI, T_GPS_WORKFLOW_STATES WS where I.INSTANCE_ID = GI.INSTANCE_ID AND GI.ACTIVE=1 AND GI.CURRENT_STATE_ID = WS.STATE_ID AND WS.STATE_DESCRIPTOR = 'Workflow End' group by to_char(GI.created_date, 'MON-YYYY'), I.application_id ) b on a.month_year = b.month_year and a.application_id = b.application_id ORDER BY TO_DATE(a.month_year, 'MON-YYYY')
 
Possibly Referenced Tables/Views:


Close relationships: