eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GMS_DEFAULT_REPORTS_V

Source

View Text - Preformatted


SELECT DR.DEFAULT_REPORT_ID , DR.AWARD_ID , DR.REPORT_TEMPLATE_ID , RT.REPORT_NAME , LP_2.MEANING , LP_1.MEANING , DR.FREQUENCY , DR.DUE_WITHIN_DAYS , SU.SITE_USE_ID , DR.COPY_NUMBER ,DR.LAST_UPDATE_DATE ,DR.LAST_UPDATED_BY ,DR.CREATION_DATE ,DR.CREATED_BY ,DR.LAST_UPDATE_LOGIN ,DR.ROWID FROM GMS_DEFAULT_REPORTS DR, GMS_REPORT_TEMPLATES RT, GMS_LOOKUPS LP_1, GMS_LOOKUPS LP_2, HZ_CUST_SITE_USES SU WHERE DR.REPORT_TEMPLATE_ID = RT.REPORT_TEMPLATE_ID AND DR.SITE_USE_ID = SU.SITE_USE_ID(+) AND LP_1.LOOKUP_TYPE = 'REPORT_FREQUENCY' AND DR.FREQUENCY = LP_1.LOOKUP_CODE AND LP_2.LOOKUP_TYPE = 'REPORT_TYPE' AND RT.TYPE = LP_2.LOOKUP_CODE

View Text - HTML Formatted

SELECT DR.DEFAULT_REPORT_ID
, DR.AWARD_ID
, DR.REPORT_TEMPLATE_ID
, RT.REPORT_NAME
, LP_2.MEANING
, LP_1.MEANING
, DR.FREQUENCY
, DR.DUE_WITHIN_DAYS
, SU.SITE_USE_ID
, DR.COPY_NUMBER
, DR.LAST_UPDATE_DATE
, DR.LAST_UPDATED_BY
, DR.CREATION_DATE
, DR.CREATED_BY
, DR.LAST_UPDATE_LOGIN
, DR.ROWID
FROM GMS_DEFAULT_REPORTS DR
, GMS_REPORT_TEMPLATES RT
, GMS_LOOKUPS LP_1
, GMS_LOOKUPS LP_2
, HZ_CUST_SITE_USES SU
WHERE DR.REPORT_TEMPLATE_ID = RT.REPORT_TEMPLATE_ID
AND DR.SITE_USE_ID = SU.SITE_USE_ID(+)
AND LP_1.LOOKUP_TYPE = 'REPORT_FREQUENCY'
AND DR.FREQUENCY = LP_1.LOOKUP_CODE
AND LP_2.LOOKUP_TYPE = 'REPORT_TYPE'
AND RT.TYPE = LP_2.LOOKUP_CODE