[Home] [Help] [Dependency Information]
Object Name: | OKS_PRODUCTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKS.OKS_PRODUCTS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
START_DATE | DATE | Start Date | ||
END_DATE | DATE | End Date | ||
CONTRACT_ID | NUMBER | Yes | FK to Contract Header. | |
LINE_ID | NUMBER | Contract Line Identifier( For Extended Warranty) | ||
PRODUCT_LINE_ID | NUMBER | Yes | Contract Line Identifier( For Covered Product Under Extended Warranty) | |
PRODUCT_LINE_LSE_ID | NUMBER | Yes | Product Line LSE Identifier | |
COVERED_LEVEL | VARCHAR2 | (150) | Level Of the Coverage (Covered Product, Covered Site, Covered Customer Etc.) | |
OBJECT_ID | VARCHAR2 | (40) | Object Identifier | |
QUANTITY | NUMBER | Quantity | ||
QTY_UOM | VARCHAR2 | (3) | Code For Unit Of Measure | |
PRICE | NUMBER | Negotiated Price for the product |
Cut, paste (and edit) the following text to query this object:
SELECT START_DATE
, END_DATE
, CONTRACT_ID
, LINE_ID
, PRODUCT_LINE_ID
, PRODUCT_LINE_LSE_ID
, COVERED_LEVEL
, OBJECT_ID
, QUANTITY
, QTY_UOM
, PRICE
FROM APPS.OKS_PRODUCTS_V;
APPS.OKS_PRODUCTS_V is not referenced by any database object
|
|
|