View HLPDTEST.STATEGPS.XXT_PROJECT_NAME_V | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Apr 12 01:05 IST 2021 |
View Definition:
select distinct d.state_id,a.application_id,a.application_name
from
t_gps_applications a,
t_gps_workflow_types b,
t_gps_workflow_states c,
t_project_task d
where d.state_id=c.state_id
and c.workflow_type_id=b.workflow_type_id
and b.application_id=a.application_id
and (a.visible_flag = 'true' or a.visible_flag is null)
Possibly Referenced Tables/Views:
![]() ![]() |