eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OKS.OKS_REPORT_TEMPLATES

Object Details

Object Name:	OKS_REPORT_TEMPLATES
Object Type:	TABLE
Owner:	OKS
FND Design Data:	OKS.OKS_REPORT_TEMPLATES
Subobject Name:
Status:	VALID

This table stores report template setup details for Autoreminder.This is a detail table of OKS_TEMPLATE_SET with a foreign key reference of template_set_id. This is populated through the detail part of Define Electronic Renewal Template UI. Information gets stored in this table when user defines a template set and specifies the report details for it. If a particular Template set is used in Global Contract Defaults, autoreminder program uses that Template Set to find out which report is to be sent to customer depending on the effectivity and duration/period. Contract status gets updated with the value of status column after an autoreminder is sent.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Internal Unique Identifier of a Report Template
REPORT_ID	NUMBER			Report identifier.
TEMPLATE_SET_ID	NUMBER		Yes	Template set identifier.
TEMPLATE_SET_TYPE	VARCHAR2	(90)		Used for identifying the report associated with the template
START_DATE	DATE			Date the report becomes active.
END_DATE	DATE			Date the report becomes inactive.
REPORT_DURATION	NUMBER			Used along with report period in Auto reminders for eligibility criteria.
REPORT_PERIOD	VARCHAR2	(3)		Unit of measure for period of time.
CREATED_BY	NUMBER	(15)	Yes	ID of the user whom created the record.
CREATION_DATE	DATE		Yes	Date the record was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	ID of the last user who updated the record.
LAST_UPDATE_DATE	DATE		Yes	Date the record was last updated.
LAST_UPDATE_LOGIN	NUMBER	(15)		OS ID of the user who last updated the record.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
STS_CODE	VARCHAR2	(30)		Status code to be used to update the contract status after sending the auto reminder or Electronic renewal
PROCESS_CODE	VARCHAR2	(30)		Indicates if the template is to be applied to Online(ERN), Manual (NSR) or Both negotiation processes
APPLIES_TO	VARCHAR2	(30)		Indicates if the templated is to be used for New, Renewed or Both contracts
ATTACHMENT_NAME	VARCHAR2	(150)		If the template is used to generate an attachment, the name of the attachment
MESSAGE_TEMPLATE_ID	NUMBER			Specify the layout template to be used for the cover document (message) which would be sent with the document type

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

OKS.OKS_REPORT_TEMPLATES does not reference any database object

OKS.OKS_REPORT_TEMPLATES is referenced by following:

APPS: OKS_REPORT_TEMPLATES