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_COV_TYPES_B

Object Details

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

OKS_COV_TYPES_B is populated by Coverage Types setup form. This table contains the coverage type and importance level definition. E.g., G (Gold), S (Silver) and B (Bronze). The Coverage types defined here are used in the Coverage form.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
CODE	VARCHAR2	(30)	Yes	Unique Identifier code for records in OKS_COV_TYPES_B
IMPORTANCE_LEVEL	NUMBER			Importance level associated to the Coverage type. Used by Service Application to prioritize their task or service.
ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate that the coverage type record is enabled to be used
START_DATE_ACTIVE	DATE			Specifies the date when the coverage type is allowed to be used
END_DATE_ACTIVE	DATE			Specifies the date when the coverage type is no longer effective
CREATED_BY	NUMBER	(15)	Yes	ID of the user who 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_LOGIN	NUMBER	(15)		OS ID of the user who last updated the record
LAST_UPDATE_DATE	DATE		Yes	Date the record was last updated
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Typically, a reference field from which a descriptive flexfield can get a context field value (optional, but recommended)
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield

Query Text

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


SELECT CODE
,      IMPORTANCE_LEVEL
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM OKS.OKS_COV_TYPES_B;

Dependencies

[top of page]

OKS.OKS_COV_TYPES_B does not reference any database object

OKS.OKS_COV_TYPES_B is referenced by following:

OKS: OKS_COV_TYPES_B#