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]

VIEW: APPS.OKS_COV_TYPES_V

Object Details

Object Name:	OKS_COV_TYPES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKS.OKS_COV_TYPES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

OKS_COV_TYPES_V is based on OKS_COV_TYPES_B and OKS_COV_TYPES_TL tables and shows records for the language determined by the environment variable userenv ('LANG'). OKS_COV_TYPES_V is used in the List of values for the column 'Coverage Type' on Coverage form.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique Identifier
CODE	VARCHAR2	(30)	Yes	Coverage type code
MEANING	VARCHAR2	(80)	Yes	Meaning of the Coverage type
DESCRIPTION	VARCHAR2	(240)		Description of the Coverage type
IMPORTANCE_LEVEL	NUMBER			Importance level associated to the Coverage type
SFWT_FLAG	VARCHAR2	(3)	Yes	Indicates a value was changed in another language. Not fully implemented in 11i.
ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate the record is enabled
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 used
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 ROW_ID
,      CODE
,      MEANING
,      DESCRIPTION
,      IMPORTANCE_LEVEL
,      SFWT_FLAG
,      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 APPS.OKS_COV_TYPES_V;

Dependencies

[top of page]

APPS.OKS_COV_TYPES_V references the following:

APPS: OKS_COV_TYPES_B; OKS_COV_TYPES_TL

APPS.OKS_COV_TYPES_V is referenced by following:

APPS: CS_SR_UWQ_EMPLOYEE_V; CS_SR_UWQ_HTML_EMPLOYEE_V; CS_SR_UWQ_HTML_TEAM_V; CS_SR_UWQ_TEAM_V; CS_SR_UWQ_UNOWNED_SEC_V; CS_SR_UWQ_UNOWNED_V; OKS_CVP_PVT - show dependent code; OKS_CVP_PVT - show dependent code; OKS_ENTITLEMENTS_PVT - show dependent code; OKS_ENTITLEMENTS_WEB - show dependent code; OKS_ENT_UTIL_PVT - show dependent code; OKS_MASSCHANGE_PVT - show dependent code