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

VIEW: APPS.OKS_PRODUCTS_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.OKS_PRODUCTS_V references the following:

SchemaAPPS
ViewOKC_K_HEADERS_V
ViewOKC_K_ITEMS_V
ViewOKC_K_LINES_V
ViewOKC_LINE_STYLES_V
PL/SQL PackageOKC_UTIL - show dependent code

APPS.OKS_PRODUCTS_V is not referenced by any database object