View HLPDTEST.STATEGPS.T_WIDGETS_ASSIGNMENT_VW | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Tue May 24 01:05 IST 2022 |
View Definition:
select "USERID","USERNAME","ROLE_NAME","OBJECT_ID","APPLICATION_NAME","OBJECT_TYPE","OBJECT_NAME","ORDERR","SUBSCRIPTION_ID","USER_ID","STATUS","DISPLAY_NAME","IS_FIXED_WIDGET","ORDER_ID","OBJECTID"
from (select *
from (select T_USERS.user_id USERID, T_USERS.user_name USERNAME, T_ROLES.Role_Name
from TAS.T_USERS T_USERS, TAS.T_USER_ROLES, TAS.T_ROLES
where t_users.user_id = t_user_roles.user_id
and t_roles.role_id = t_user_roles.role_id
and t_roles.role_name = 'EIS_EMPLOYEE') all_users,
(select a.*,
decode(a.object_name,
'Employee Happiness at Work',
'1',
'Employee Happiness with his/her Performance',
'2',
'Do you know that customers perceive TRINITI is weak in Project Management?',
'3',
'Do you agree that TRINITI is weak in Project Management?',
'4',
'Do you want to improve your project management skills so that we eliminate the perception that TRINITI is weak in project management?',
'5') orderr
from t_Gps_All_Objects a
where a.object_type = 'Custom Module'
and a.application_name = 'Triniti Corporation'
and (a.object_name = 'Employee Happiness at Work' or
a.object_name =
'Employee Happiness with his/her Performance' or
a.object_name = 'Do you know that customers perceive TRINITI is weak in Project Management?' or
a.object_name = 'Do you agree that TRINITI is weak in Project Management?' or
a.object_name = 'Do you want to improve your project management skills so that we eliminate the perception that TRINITI is weak in project management?')) ) specific_objects,
(SELECT T_GPS_OBJECT_SUBSCRIPTIONS.SUBSCRIPTION_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,
T_GPS_OBJECT_SUBSCRIPTIONS.OBJECT_ID OBJECTID
FROM STATEGPS.T_GPS_OBJECT_SUBSCRIPTIONS T_GPS_OBJECT_SUBSCRIPTIONS,
STATEGPS.T_GPS_ALL_OBJECTS T_GPS_ALL_OBJECTS,
tas.t_users t_users
where T_GPS_OBJECT_SUBSCRIPTIONS.OBJECT_ID =
T_GPS_ALL_OBJECTS.OBJECT_ID
AND T_GPS_OBJECT_SUBSCRIPTIONS.USER_ID = T_USERS.USER_ID
AND T_GPS_OBJECT_SUBSCRIPTIONS.STATUS = 'Subscribed') all_subscriptions
where specific_objects.object_id = all_subscriptions.OBJECTID(+)
and specific_objects.USERID = all_subscriptions.user_id(+)
order by orderr desc
Possibly Referenced Tables/Views:
![]() ![]() |