[Home] [Help] [Dependency Information]
Object Name: | OKL_PDT_PQYS |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_PDT_PQYS |
Subobject Name: | |
Status: | VALID |
DEFINITION
Holds the association of qualities with product Template . During the whole setup process, Qualities are attached to the Product Template and the values for each of these are assigned during the Product setup
BPO (buyout purchase option) which is a Quality and is attached to a product template ,BPO has its corresponding Values like FMV,DOLLARONE,1000(these are attached at the product level).
EXAMPLE
Product Template Qualitys
OP Lease Asset Sub Category
EXAMPLE
MISCELLANEOUS
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_PDT_PQYS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKL_PDT_PQYS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PTL_ID
PQY_ID |
PDQ_PQY_FK_I | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PQY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
PTL_ID | NUMBER | Yes | Foreign key to table OKL_PDT_TEMPLATES | |
PQY_ID | NUMBER | Yes | Foreign key to table OKL_PDT_QUALITYS | |
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
, PTL_ID
, PQY_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_PQYS;
OKL.OKL_PDT_PQYS does not reference any database object
OKL.OKL_PDT_PQYS is referenced by following:
|
|
|