[Home] [Help] [Dependency Information]
Object Name: | OKL_PTL_PTQ_VALS |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_PTL_PTQ_VALS |
Subobject Name: | |
Status: | VALID |
DEFINITION
Holds the association of Template Qualities and Values with Product Template.For example for a Product template named Lease there could be template quality named intrested method with eighter simple or compound intrest as there values.
EXAMPLE
Product Template Template Quality Value
OP Lease Asset Category All
Interest Method Simple
Compound
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_PTL_PTQ_VALS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKL_PTL_PTQ_VALS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PTL_ID
PTQ_ID |
PMV_PTQ_FK_I | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PTQ_ID |
PMV_PTV_FK_I | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PTV_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
PTL_ID | NUMBER | Yes | Foreign key to table OKL_PDT_TEMPLATES | |
PTQ_ID | NUMBER | Yes | Foreign key to table OKL_PTL_QUALITYS | |
PTV_ID | NUMBER | Yes | Foreign key to table OKL_PTQ_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
, PTL_ID
, PTQ_ID
, PTV_ID
, OBJECT_VERSION_NUMBER
, FROM_DATE
, TO_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM OKL.OKL_PTL_PTQ_VALS;
OKL.OKL_PTL_PTQ_VALS does not reference any database object
OKL.OKL_PTL_PTQ_VALS is referenced by following:
|
|
|