Product: | OKS - Service Contracts |
---|---|
Description: | This view is used to show the xslt report templates for electronic renewal. |
Implementation/DBA Data: | APPS.OKS_REPORT_TEMPLATES_V |
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
FROM OKS_REPORT_TEMPLATES RTMP