[Home] [Help] [Dependency Information]
Object Name: | OKL_PDT_PQY_VALS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_PDT_PQY_VALS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
DEFINITION
Product Qualities Values are defined at the product level. For example Asset Sub Category which is a Quality and is attached to a product template , Asset Sub Category has its corresponding Values like Trucks, Haulers, Desks(these are attached at the product level).
EXAMPLE
Product Qualitys Value
USOPTX Asset Sub Category Trucks
Haulers
Tractors
Desks
Chairs
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier in the database | |
ID | NUMBER | Yes | Primary key column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
PDQ_ID | NUMBER | Yes | Foreign key to table OKL_PDT_PQYS | |
PDT_ID | NUMBER | Yes | Foreign key to table OKL_PRODUCTS | |
QVE_ID | NUMBER | Yes | Foreign key to table OKL_PQY_VALUES | |
FROM_DATE | DATE | Yes | From date | |
TO_DATE | DATE | To date | ||
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, PDQ_ID
, PDT_ID
, QVE_ID
, FROM_DATE
, TO_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.OKL_PDT_PQY_VALS_V;
|
|
|