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_ENT_COVERAGES_V

Object Details

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

View Type

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

View all Coverages attcahed to a Contract Line

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACTUAL_COVERAGE_ID	NUMBER			Coverage Term Identifier
CONTRACT_ID	NUMBER		Yes	FK to Contract Header.
CONTRACT_NUMBER	VARCHAR2	(120)	Yes	With CONTRACT_NUMBER_MODIFIER, used to uniquely identify a contract as a business entity.
CONTRACT_LINE_ID	NUMBER		Yes	Service Line Identifier(Top Line Identifier)
SERVICE_ITEM_ID	NUMBER			Service Item Identifier
COVERAGE_NAME	VARCHAR2	(150)		User name given to a free-format coverage term line
COVERAGE_DESC	VARCHAR2	(1995)		Description of the Coverage term line item
COVERAGE_MEANING	VARCHAR2	(80)		Coverage Meaning. (Eg: Gold Coverage, Silver Coverage, Bronze Coverage Etc)
START_DATE	DATE			The date the Coverage line becomes active
END_DATE	DATE			The date the coverage line expires
DATE_TERMINATED	DATE			Date Terminated of the Coverage line
EXCEPTION_COVERAGE_ID	NUMBER			Exception Coverage Identifier Stored as a Rule.
STANDARD_COV_YN	VARCHAR2	(1)		Flag to indicate if the contract line is associated with a standard coverage

Query Text

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


SELECT ACTUAL_COVERAGE_ID
,      CONTRACT_ID
,      CONTRACT_NUMBER
,      CONTRACT_LINE_ID
,      SERVICE_ITEM_ID
,      COVERAGE_NAME
,      COVERAGE_DESC
,      COVERAGE_MEANING
,      START_DATE
,      END_DATE
,      DATE_TERMINATED
,      EXCEPTION_COVERAGE_ID
,      STANDARD_COV_YN
FROM APPS.OKS_ENT_COVERAGES_V;

Dependencies

[top of page]

APPS.OKS_ENT_COVERAGES_V references the following:

APPS: OKC_K_HEADERS_ALL_B; OKC_K_ITEMS; OKC_K_LINES_B; OKC_K_LINES_TL; OKS_COV_TYPES_TL; OKS_K_LINES_B

APPS.OKS_ENT_COVERAGES_V is referenced by following:

APPS: CSD_CHARGE_LINE_UTIL - show dependent code; CSD_ESTIMATES_FROM_BOM_PVT - show dependent code; CSM_CONTR_HEADERS_V; CS_CONTRACT_COVERAGES_V; CS_EST_APPLY_CONTRACT_PKG - show dependent code