[Home] [Help] [Dependency Information]
Object Name: | OKS_TEMPLATE_SET |
---|---|
Object Type: | TABLE |
Owner: | OKS |
FND Design Data: | OKS.OKS_TEMPLATE_SET |
Subobject Name: | |
Status: | VALID |
This table stores template set information that is used to generate quote letter and cover letter for Electronic Renewal and Autoreminder. This table is populated through the header part of Define Electronic Renewal Template UI.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Internal Unique Identifier of a Template set. | |
NAME | VARCHAR2 | (120) | Template set name. | |
DESCRIPTION | VARCHAR2 | (2000) | Description of the Template set. | |
START_DATE | DATE | Date the template becomes active. | ||
END_DATE | DATE | Date the template becomes inactive. | ||
ORG_ID | NUMBER | Obsolete | ||
QUOTE_LETTER | NUMBER | Obsolete, moved to OKC_REPORT_TEMPLATES | ||
COVER_LETTER | NUMBER | Obsolete, moved to OKC_REPORT_TEMPLATES | ||
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) | Obsolete, moved to OKC_REPORT_TEMPLATES | |
TEMPLATE_SOURCE | VARCHAR2 | (10) |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, NAME
, DESCRIPTION
, START_DATE
, END_DATE
, ORG_ID
, QUOTE_LETTER
, COVER_LETTER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, STS_CODE
, TEMPLATE_SOURCE
FROM OKS.OKS_TEMPLATE_SET;
OKS.OKS_TEMPLATE_SET does not reference any database object
OKS.OKS_TEMPLATE_SET is referenced by following:
|
|
|