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.

[Home] [Help]

View: GMS_DEFAULT_REPORTS_V

Product:	GMS - Grants Accounting
Description:	- Retrofitted - Retrofitted
Implementation/DBA Data:	APPS.GMS_DEFAULT_REPORTS_V

View Text

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

Columns

Name
DEFAULT_REPORT_ID
AWARD_ID
REPORT_TEMPLATE_ID
REPORT_NAME
TYPE_DIS
FREQUENCY_DIS
FREQUENCY
DUE_WITHIN_DAYS
SITE_USE_ID
COPY_NUMBER
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ROW_ID