View HLPDTEST.STATEGPS.T_SLA_ESCALATION_V 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
SLA_ID number 22  √  null
T_PROJECT_SLAS.SLA_ID Implied Constraint R
EMAIL_ID varchar2 255  √  null
RULE_EXPRESSION varchar2 2000  √  null
ESCALATION_ID number 22
T_PROJECT_SLAS_ESCALATIONS.ESCALATION_ID Implied Constraint R
TYPE varchar2 50  √  null

Analyzed at Thu Aug 13 01:05 IST 2020

View Definition:
select sla_id, b.email_id,rule_expression,escalation_id,type from ( WITH DATA AS (select mail_to,rule_expression,sla_id,escalation_id, type from T_PROJECT_SLAS_ESCALATIONs a /*where a.type = 'Response'*/ /*and sla_id in (42)*/ /* order by sla_id asc*/) SELECT trim(regexp_substr(mail_to, '[^,]+', 1, LEVEL)) mail_to, rule_expression,sla_id,escalation_id,type FROM DATA CONNECT BY LEVEL <= regexp_count(mail_to, ',') + 1) slas_data, tas.t_users b where mail_to=b.user_name order by email_id
 
Possibly Referenced Tables/Views:


Close relationships: