View HLPDTEST.STATEGPS.OBJECT_VIEWER_V | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Apr 12 01:05 IST 2021 |
View Definition:
select
i.instance_id,
a.application_name,
wt.workflow_type_name,
w_to_s.state_name to_state,
w_from_s.state_name from_state,
--ip.property_name,
ip.property_value
from
stategps.t_gps_instances i,
stategps.t_gps_applications a,
stategps.t_gps_workflow_types wt,
stategps.t_gps_workflow_states w_to_s,
stategps.t_gps_workflow_states w_from_s,
stategps.t_gps_instance_properties ip
where
i.application_id=a.application_id(+)
and i.workflow_type_id=wt.workflow_type_id(+)
and i.current_state_id=w_to_s.state_id(+)
and i.from_state_id=w_from_s.state_id(+)
and i.instance_id=ip.instance_id
Order By
i.instance_id, i.current_state_id
Possibly Referenced Tables/Views:
![]() ![]() |