[Home] [Help] [Dependency Information]
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 |
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
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 |
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;
|
|
|