View HLPDTEST.STATEGPS.V_INSTANCE_PROPS | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Wed May 25 01:05 IST 2022 |
View Definition:
select i.instance_id, i.priority, property_value AS IA_ISSUE_NUMBER,
(select property_value from t_gps_instance_properties where instance_id = ip.instance_id
and property_name = 'tri2.SG_TRI2_ENTITY.IA_ISSUE_TITLE')
IA_ISSUE_TITLE
from t_gps_instance_properties ip, t_instances i
where ip.instance_id = i.instance_id
and property_name = 'tri2.SG_TRI2_ENTITY.IA_ISSUE_NUMBER'
and property_value is not null
Possibly Referenced Tables/Views:
![]() ![]() |