Product: | GMS - Grants Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GMS_REPORTS_V |
SELECT R.REPORT_ID
, R.INSTALLMENT_ID
, R.REPORT_TEMPLATE_ID
, RT.REPORT_NAME
, LP_1.MEANING
, R.SITE_USE_ID
, R.COPY_NUMBER
, R.DUE_DATE
, R.DATE_FILED
, R.FILED_BY
, PER.FULL_NAME
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.CREATION_DATE
, R.CREATED_BY
, R.LAST_UPDATE_LOGIN
, R.ROWID
FROM GMS_REPORTS R
, GMS_REPORT_TEMPLATES RT
, GMS_LOOKUPS LP_1
, HZ_CUST_SITE_USES SU
, PER_PEOPLE_X PER
WHERE R.REPORT_TEMPLATE_ID = RT.REPORT_TEMPLATE_ID
AND R.SITE_USE_ID = SU.SITE_USE_ID(+)
AND LP_1.LOOKUP_TYPE = 'REPORT_TYPE'
AND RT.TYPE = LP_1.LOOKUP_CODE
AND PER.PERSON_ID(+) = R.FILED_BY