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_LINE_DETAILS_V

Object Details

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

View Type

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

This view can be used to get contract header/line/coverage level information for a contract line of type service/warranty/extended warranty. This view should always be filtered using service_line_id

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONTRACT_ID	NUMBER		Yes	Unique identifier of Contract.
CONTRACT_NUMBER	VARCHAR2	(120)	Yes	Contract (RFP,Proposal etc.) Legal Identifier.
MODIFIER	VARCHAR2	(120)		A unique internal name for the contract number. Conbination of contract number and modifier are unique for a contract
SERVICE_LINE_ID	NUMBER		Yes	Contract line of line type service/warranty/extended warranty
SERVICE_NAME	VARCHAR2	(40)		Service item name.
SERVICE_DESCRIPTION	VARCHAR2	(240)		Service item description.
COVERAGE_LINE_ID	NUMBER		Yes	Unique Identifier of Coverage.
COVERAGE_NAME	VARCHAR2	(150)		Coverage Name
COVERAGE_DESCRIPTION	VARCHAR2	(1995)		Description of Coverage.
SERVICE_START_DATE	DATE			Effective Start Date of Contract line. The beginning of the active period, one second after midnight on the date indicated.
SERVICE_END_DATE	DATE			Effective End Date of Contract line. The end of the active period, one second before midnight on the date indicated.
WARRANTY_FLAG	VARCHAR2	(1)		Warranty flag. If Contract line is warranty the value is Y else the value would be N.
STATUS_CODE	VARCHAR2	(30)	Yes	Status Code of the contract line. Unique identifier of status code. Refers to status OKC_STATUSES_B.
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 CONTRACT_ID
,      CONTRACT_NUMBER
,      MODIFIER
,      SERVICE_LINE_ID
,      SERVICE_NAME
,      SERVICE_DESCRIPTION
,      COVERAGE_LINE_ID
,      COVERAGE_NAME
,      COVERAGE_DESCRIPTION
,      SERVICE_START_DATE
,      SERVICE_END_DATE
,      WARRANTY_FLAG
,      STATUS_CODE
,      STANDARD_COV_YN
FROM APPS.OKS_ENT_LINE_DETAILS_V;

Dependencies

[top of page]

APPS.OKS_ENT_LINE_DETAILS_V references the following:

APPS: MTL_SYSTEM_ITEMS_B_KFV; OKC_K_HEADERS_ALL_B; OKC_K_ITEMS; OKC_K_LINES_B; OKC_K_LINES_V; OKS_K_LINES_B

APPS.OKS_ENT_LINE_DETAILS_V is referenced by following:

APPS: CSF_DEBRIEF_TASKS_V; CS_CHARGE_DETAILS_PVT - show dependent code; CS_ERES_INT_PKG - show dependent code