View HLPDTEST.STATEGPS.T_TICKET_DETAILS_V | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Mar 01 01:05 IST 2021 |
View Definition:
select (SELECT APPLICATION_NAME
FROM T_GPS_APPLICATIONS tga
WHERE tga.APPLICATION_ID = i.PROJECT_ID) APPLICATION_NAME,
tga.application_id,
tgwt.workflow_type_name,
tgwt.workflow_type_id,
ti.instance_id,
tgws.state_id,
ATTRIBUTE22 region,
ATTRIBUTE23 country,
ATTRIBUTE24 entity,
i.application_module,
i.issue_number,
i.issue_title,
tpcp.priority,
ti.priority priority_number,
ATTRIBUTE6 ticket_type,
ATTRIBUTE7 change_type,
ATTRIBUTE2 migration_type,
tpt.user_name,
(SELECT k.first_name || ' ' || k.middle_name || ' ' || k.last_name
from tas.t_users k
where k.user_name = tpt.user_name) user_full_name,
tgws.state_name,
i.created_date,
(SELECT k.first_name || ' ' || k.middle_name || ' ' || k.last_name
from tas.t_users k
where k.user_id = i.created_by) created_by,
i.parent_issue_number,
tpt.project_task_id,
i.Attribute1 incident_number,'STARTED' status,tgws.state_order,tpt.resource_name,i.attribute3,
i.attribute4,i.attribute5,i.due_date
from t_gps_applications tga,
t_gps_app_properties tgap,
t_gps_workflow_types tgwt,
t_gps_workflow_states tgws,
t_project_task tpt,
t_instances ti,
t_gps_instances tgi,
tri2gps_dev.issues i,
t_project_custom_priority tpcp
where tga.application_id = tgwt.application_id
and tga.application_id = tgap.application_id
and tgwt.workflow_type_id = tgws.workflow_type_id
and tpt.instance_id = ti.instance_id
and ti.instance_id = i.instance_id
and tgi.instance_id = i.instance_id
and tgws.state_id = tpt.state_id
and tgws.state_id = tgi.current_state_id
and tpt.state_id = tgi.current_state_id
and ti.application_id = tga.application_id
and ti.workflow_type_id = tgwt.workflow_type_id
and ti.priority = tpcp.start_range
and tga.visible_flag = 'true'
and tgwt.visible_flag = 'true'
and ti.active = 1
and tgi.instance_present = 1
--and issue_number='IS000142'
and tgap.property_name = 'TICKET_MANAGEMENT_APPLICATION'
and tgap.property_value = 'TRUE'
union
select (SELECT APPLICATION_NAME
FROM T_GPS_APPLICATIONS tga
WHERE tga.APPLICATION_ID = i.PROJECT_ID) APPLICATION_NAME,
tga.application_id,
tgwt.workflow_type_name,
tgwt.workflow_type_id,
ti.instance_id,
tgws.state_id,
ATTRIBUTE22 region,
ATTRIBUTE23 country,
ATTRIBUTE24 entity,
i.application_module,
i.issue_number,
i.issue_title,
tpcp.priority,
ti.priority priority_number,
ATTRIBUTE6 ticket_type,
ATTRIBUTE7 change_type,
ATTRIBUTE2 migration_type,
tpt.user_name,
(SELECT k.first_name || ' ' || k.middle_name || ' ' || k.last_name
from tas.t_users k
where k.user_name = tpt.user_name) user_full_name,
tgws.state_name,
i.created_date,
(SELECT k.first_name || ' ' || k.middle_name || ' ' || k.last_name
from tas.t_users k
where k.user_id = i.created_by) created_by,
i.parent_issue_number,
tpt.project_task_id,
i.Attribute1 incident_number,'NOT STARTED' status,tgws.state_order,tpt.resource_name,i.attribute3,
i.attribute4,i.attribute5,i.due_date
from t_gps_applications tga,
t_gps_app_properties tgap,
t_gps_workflow_types tgwt,
t_gps_workflow_states tgws,
t_project_task tpt,
t_instances ti,
tri2gps_dev.issues i,
t_project_custom_priority tpcp
where tga.application_id = tgwt.application_id
and tga.application_id = tgap.application_id
and tgwt.workflow_type_id = tgws.workflow_type_id
and tpt.instance_id = ti.instance_id
and ti.instance_id = i.instance_id
and tgws.state_id = tpt.state_id
and ti.application_id = tga.application_id
and ti.workflow_type_id = tgwt.workflow_type_id
and ti.priority = tpcp.start_range
and tga.visible_flag = 'true'
and tgwt.visible_flag = 'true'
and ti.active = 1
and tgap.property_name = 'TICKET_MANAGEMENT_APPLICATION'
--and issue_number='IS000142'
and (tpt.daysremaining is null or tpt.daysremaining <> 0)
and not exists(select 1 from t_gps_instances tgi where tgi.instance_id=ti.instance_id
and tgi.current_state_id=tpt.state_id and instance_present=1)
and tgap.property_value = 'TRUE'
Possibly Referenced Tables/Views:
![]() ![]() |