[Home] [Help] [Dependency Information]
Object Name: | OKS_CUST_PRODUCTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKS.OKS_CUST_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 |
---|---|---|---|---|
CLE_ID | NUMBER | Unique Identifier for Contract Line. | ||
EFFECTIVE_START_DATE | DATE | Effective Start Date of the Contract Line | ||
EFFECTIVE_END_DATE | DATE | Effective End Date of the Contract Line | ||
PRODUCT_NAME | VARCHAR2 | (240) | Product's Inventory Item Name (Derived from Segment1) | |
CURRENT_SERIAL_NUMBER | VARCHAR2 | (30) | Current Serial Number of the product | |
ADDRESS | VARCHAR2 | (960) | Address where the Product is installed | |
INSTALLATION_DATE | DATE | Product Installation Date | ||
QUANTITY | NUMBER | Yes | Quantity Of the Product | |
UOM_CODE | VARCHAR2 | (3) | Yes | Unit Of Measure Code |
REFERENCE_NUMBER | VARCHAR2 | (30) | Yes | Reference Number of the Product |
NET_AMOUNT | NUMBER | Original Net Amount of the product |
Cut, paste (and edit) the following text to query this object:
SELECT CLE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, PRODUCT_NAME
, CURRENT_SERIAL_NUMBER
, ADDRESS
, INSTALLATION_DATE
, QUANTITY
, UOM_CODE
, REFERENCE_NUMBER
, NET_AMOUNT
FROM APPS.OKS_CUST_PRODUCTS_V;
APPS.OKS_CUST_PRODUCTS_V is not referenced by any database object
|
|
|