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

VIEW: APPS.OKS_COVDLEVEL_DETAILS_V

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


This view is used to show the service details of a contract. This included all covered levels.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CONCATENATED_LINE_NUMBER VARCHAR2 (301)
Concatenated line number.ie, Topline linenumber || '.' || subline linenumber.
LINE_NUMBER VARCHAR2 (150) Yes Covered Level Line Number
LINE_TYPE VARCHAR2 (150)
Line Type. eg: covered product, covered party etc.
LSE_ID NUMBER
Yes Line Style Identifier
LINE_REF VARCHAR2 (300)
Line Reference.
LINE_START_DATE DATE

Covered level start date
LINE_END_DATE DATE

Covered level end date
LINE_STATUS VARCHAR2 (30) Yes Covered level status
LINE_AMOUNT NUMBER

Covered level amount
ID NUMBER
Yes Covered level Identifier
CHR_ID NUMBER

Unique Identifier for Contract Header
DNZ_CHR_ID NUMBER
Yes Unique Identifier for Contract Header, denomalized for efficiency.
CLE_ID NUMBER

Unique Identifier for Contract Line.
Query Text

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


SELECT CONCATENATED_LINE_NUMBER
,      LINE_NUMBER
,      LINE_TYPE
,      LSE_ID
,      LINE_REF
,      LINE_START_DATE
,      LINE_END_DATE
,      LINE_STATUS
,      LINE_AMOUNT
,      ID
,      CHR_ID
,      DNZ_CHR_ID
,      CLE_ID
FROM APPS.OKS_COVDLEVEL_DETAILS_V;

Dependencies

[top of page]

APPS.OKS_COVDLEVEL_DETAILS_V references the following:

SchemaAPPS
SynonymOKC_K_LINES_B
ViewOKC_K_LINES_V
ViewOKC_LINE_STYLES_V

APPS.OKS_COVDLEVEL_DETAILS_V is not referenced by any database object