VIEW: APPS.GMS_REPORTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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