[Home] [Help]
View: GMS_REPORT_TEMPLATES_V
View Text
SELECT RT.REPORT_TEMPLATE_ID
, RT.REPORT_NAME
, RT.TYPE
, LP.MEANING
, RT.TRANSACTION_NUMBER
, RT.START_DATE_ACTIVE
, RT.END_DATE_ACTIVE
, RT.AGENCY_SPECIFIC_FORM
, RT.LAST_UPDATE_DATE
, RT.LAST_UPDATED_BY
, RT.CREATION_DATE
, RT.CREATED_BY
, RT.LAST_UPDATE_LOGIN
, RT.ROWID
FROM GMS_REPORT_TEMPLATES RT
, GMS_LOOKUPS LP
WHERE LP.LOOKUP_TYPE = 'REPORT_TYPE'
AND LP.LOOKUP_CODE = RT.TYPE
Columns
| Name |
| TEMPLATE_ID |
| REPORT_NAME |
| TYPE |
| MEANING |
| TRANSACTION_NUMBER |
| START_DATE_ACTIVE |
| END_DATE_ACTIVE |
| AGENCY_SPECIFIC_FORM |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_LOGIN |
| ROW_ID |
APPS.GMS_REPORT_TEMPLATES_V