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