[Home] [Help] [Dependency Information]
Object Name: | OKL_PDT_PQY_VALS |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_PDT_PQY_VALS |
Subobject Name: | |
Status: | VALID |
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_PDT_PQY_VALS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKL_PDT_PQY_VALS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PDQ_ID
PDT_ID |
PQV_PDT_FK_I | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PDT_ID |
PQV_QVE_FK_I | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | QVE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
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 | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
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 ID
, PDQ_ID
, PDT_ID
, QVE_ID
, OBJECT_VERSION_NUMBER
, FROM_DATE
, TO_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM OKL.OKL_PDT_PQY_VALS;
OKL.OKL_PDT_PQY_VALS does not reference any database object
OKL.OKL_PDT_PQY_VALS is referenced by following:
|
|
|