View HLPDTEST.STATEGPS.RECENTLY_ACCESSED_FUNCTIONS_V Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
APPLICATION_NAME varchar2 255  √  null
CUSTOM_URL varchar2 4000  √  null
USER_NAME varchar2 255  √  null
GROUP_NAME varchar2 255  √  null
DISPLAY_NAME varchar2 255  √  null
MAX date 7  √  null

Analyzed at Mon May 23 01:05 IST 2022

View Definition:
SELECT t_gps_applications.APPLICATION_NAME, nvl(T_GPS_CUSTOM_SETS.CUSTOM_URL,(REPLACE('/articles/'||t_gps_applications.application_name||T_GPS_CUSTOM_SETS.custom_set_name||'.html',' ',''))) CUSTOM_URL, t_gps_dbv_users.user_name, T_GPS_CUSTOM_SETS.GROUP_NAME, COALESCE(T_GPS_CUSTOM_SETS.DISPLAY_NAME,T_GPS_CUSTOM_SETS.CUSTOM_SET_NAME) AS DISPLAY_NAME, max(t_gps_favourites_history.accessed_time) AS max FROM t_gps_favourites_history t_gps_favourites_history, t_gps_dbv_users t_gps_dbv_users, t_gps_applications t_gps_applications, STATEGPS.T_GPS_CUSTOM_SETS T_GPS_CUSTOM_SETS WHERE t_gps_dbv_users.dbv_user_id = t_gps_favourites_history.dbv_user_id AND t_gps_favourites_history.application_id = t_gps_applications.application_id AND trunc(t_gps_favourites_history.accessed_time) >= (CURRENT_DATE - 365) AND t_gps_favourites_history.object_type = 'CUSTOM SET' -- AND T_GPS_CUSTOM_SETS.IS_HELP_DOC != 'true' and t_gps_applications.application_id = T_GPS_CUSTOM_SETS.application_id AND t_gps_favourites_history.object_name = T_GPS_CUSTOM_SETS.CUSTOM_SET_NAME AND t_gps_applications.visible_flag = 'true' AND T_GPS_CUSTOM_SETS.visible_flag = 'true' GROUP BY t_gps_applications.APPLICATION_NAME, nvl(T_GPS_CUSTOM_SETS.CUSTOM_URL,(REPLACE('/articles/'||t_gps_applications.application_name||T_GPS_CUSTOM_SETS.custom_set_name||'.html',' ',''))), t_gps_dbv_users.user_name,T_GPS_CUSTOM_SETS.GROUP_NAME,T_GPS_CUSTOM_SETS.DISPLAY_NAME,T_GPS_CUSTOM_SETS.CUSTOM_SET_NAME ORDER BY (max(t_gps_favourites_history.accessed_time)) DESC
 
Possibly Referenced Tables/Views: