View HLPDTEST.STATEGPS.T_SLA_ESCALATION_V | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Tue May 24 01:05 IST 2022 |
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:
![]() ![]() |