[Home] [Help] [Dependency Information]
Object Name: | OKS_ENT_COVERAGES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKS.OKS_ENT_COVERAGES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View all Coverages attcahed to a Contract Line
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 |
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;
|
|
|