[Home] [Help] [Dependency Information]
Object Name: | OKL_PDT_OPTS |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_PDT_OPTS |
Subobject Name: | |
Status: | VALID |
DEFINITION
After product is defined a set of options can be assigned to the contracts of that product.These
options may be mandatory or optional depending on required flag.This is an association between Product and Option entity
EXAMPLE
Product Options
----------------------------------------------
USDF Evergreen
Tax Ownership
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_PDT_OPTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKL_PDT_OPTS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
OPT_ID
PDT_ID |
PON_PDT_FK_I | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PDT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
OPT_ID | NUMBER | Yes | Foreign key to table OKL_OPTIONS | |
PDT_ID | NUMBER | Yes | Foreign key to table OKL_PRODUCTS | |
OPTIONAL_YN | VARCHAR2 | (3) | Yes | Indicates whether an optin is mandatory or optional. |
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
, OPT_ID
, PDT_ID
, OPTIONAL_YN
, OBJECT_VERSION_NUMBER
, FROM_DATE
, TO_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM OKL.OKL_PDT_OPTS;
OKL.OKL_PDT_OPTS does not reference any database object
OKL.OKL_PDT_OPTS is referenced by following:
|
|
|