VIEW: APPS.OKS_REPORT_TEMPLATES_V

Source

View Text - Preformatted

SELECT RTMP.ROWID ROW_ID , RTMP.ID ID , RTMP.REPORT_ID REPORT_ID , RTMP.TEMPLATE_SET_ID TEMPLATE_SET_ID , RTMP.TEMPLATE_SET_TYPE TEMPLATE_SET_TYPE , RTMP.START_DATE START_DATE , RTMP.END_DATE END_DATE , RTMP.REPORT_DURATION REPORT_DURATION , RTMP.REPORT_PERIOD REPORT_PERIOD , RTMP.STS_CODE STS_CODE , RTMP.CREATED_BY CREATED_BY , RTMP.CREATION_DATE CREATION_DATE , RTMP.LAST_UPDATED_BY LAST_UPDATED_BY , RTMP.LAST_UPDATE_DATE LAST_UPDATE_DATE , RTMP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , RTMP.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER , RTMP.PROCESS_CODE PROCESS_CODE , RTMP.APPLIES_TO APPLIES_TO ,RTMP.ATTACHMENT_NAME ATTACHMENT_NAME ,RTMP.MESSAGE_TEMPLATE_ID MESSAGE_TEMPLATE_ID FROM OKS_REPORT_TEMPLATES RTMP

View Text - HTML Formatted

SELECT RTMP.ROWID ROW_ID
, RTMP.ID ID
, RTMP.REPORT_ID REPORT_ID
, RTMP.TEMPLATE_SET_ID TEMPLATE_SET_ID
, RTMP.TEMPLATE_SET_TYPE TEMPLATE_SET_TYPE
, RTMP.START_DATE START_DATE
, RTMP.END_DATE END_DATE
, RTMP.REPORT_DURATION REPORT_DURATION
, RTMP.REPORT_PERIOD REPORT_PERIOD
, RTMP.STS_CODE STS_CODE
, RTMP.CREATED_BY CREATED_BY
, RTMP.CREATION_DATE CREATION_DATE
, RTMP.LAST_UPDATED_BY LAST_UPDATED_BY
, RTMP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RTMP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RTMP.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RTMP.PROCESS_CODE PROCESS_CODE
, RTMP.APPLIES_TO APPLIES_TO
, RTMP.ATTACHMENT_NAME ATTACHMENT_NAME
, RTMP.MESSAGE_TEMPLATE_ID MESSAGE_TEMPLATE_ID
FROM OKS_REPORT_TEMPLATES RTMP