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

VIEW: APPS.OKS_ENT_COVD_LEVELS_V

Object Details
Object Name: OKS_ENT_COVD_LEVELS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKS.OKS_ENT_COVD_LEVELS_V
Subobject Name:
Status: VALID

View Type

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


View Lists all Coverage Leveles with Coverage level Identifier and Service Line Identifier


[View Source]

Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Yes Contract Header Identifier
LINE_ID NUMBER
Yes Contract Line Identifier
PARENT_LINE_ID NUMBER

Contract Parent Line Line Identifer(Eg: Service is parent to the Coverage Levels)
COVERAGE_LEVEL_CODE VARCHAR2 (30) Yes Coverage Level Code. It can be a Party, Party Site, Customer, System, Item or Covered Product.
COVERAGE_LEVEL_NAME VARCHAR2 (150)
Coverage Level Name for the Coverege Level Code.
COVERAGE_LEVEL_ID NUMBER

Coverage Level Identifier. It can be a Party Identifier or Party Site Identifier etc.
Query Text

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


SELECT HEADER_ID
,      LINE_ID
,      PARENT_LINE_ID
,      COVERAGE_LEVEL_CODE
,      COVERAGE_LEVEL_NAME
,      COVERAGE_LEVEL_ID
FROM APPS.OKS_ENT_COVD_LEVELS_V;

Dependencies

[top of page]

APPS.OKS_ENT_COVD_LEVELS_V references the following:

SchemaAPPS
SynonymOKC_K_ITEMS
SynonymOKC_K_LINES_B
SynonymOKC_LINE_STYLES_B
SynonymOKC_LINE_STYLES_TL

APPS.OKS_ENT_COVD_LEVELS_V is not referenced by any database object