View HLPDTEST.STATEGPS.T_GPS_OBJECTS_UNSUBSCRIBE_VW | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Tue May 24 01:05 IST 2022 |
View Definition:
select T_GPS_OBJECT_SUBSCRIPTIONS."SUBSCRIPTION_ID",T_GPS_OBJECT_SUBSCRIPTIONS."OBJECT_ID",T_GPS_OBJECT_SUBSCRIPTIONS."USER_ID",T_GPS_OBJECT_SUBSCRIPTIONS."STATUS",T_GPS_OBJECT_SUBSCRIPTIONS."DISPLAY_NAME",T_GPS_OBJECT_SUBSCRIPTIONS."IS_FIXED_WIDGET",T_GPS_OBJECT_SUBSCRIPTIONS."ORDER_ID" from
(select T_USERS.User_Id from TAS.T_ROLES T_ROLES,TAS.T_USERS T_USERS,TAS.T_USER_ROLES
where T_USERS.user_id = T_USER_ROLES.user_id
and T_ROLES.role_id = T_USER_ROLES.role_id
and T_USERS.User_Id NOT IN (1004,3057,2207,433,382,1905,1037,412,385)
and t_roles.role_name = 'EIS_EMPLOYEE') Users, T_GPS_OBJECT_SUBSCRIPTIONS T_GPS_OBJECT_SUBSCRIPTIONS
where T_GPS_OBJECT_SUBSCRIPTIONS.Object_Id in (61,47,1)
AND T_GPS_OBJECT_SUBSCRIPTIONS.user_id= Users.user_id
Possibly Referenced Tables/Views:
![]() ![]() |