[Home] [Help] [Dependency Information]
Object Name: | OKL_OVD_RUL_TMLS |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_OVD_RUL_TMLS |
Subobject Name: | |
Status: | VALID |
DEFINITION
Association of Option Value rules with Rule Templates.
Option value rule templates are defined to enter the actual values into the rule definations define in the option value rules. These rule templates are defined in okc_rules_b through a rule template editor.
EXAMPLE
Option RULE DEFINATION
ADDRESS 'B' 'XYZ' 1 5 6 'ADD'
'S' 'XYZ' 1 5 6 ' ADD'
Where 'B'&'S' are buy & sell
'XYZ' is an option value
'ADD' is a rule.
And 1 5 6 are content org, context inv org, content asset book respectially.
Each of these option value rule can be attached to one or more templates but as show in the above senerio
that combination is invalid.since a contract cannot have rules which have both buy and sell options.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_OVD_RUL_TMLS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKL_OVD_RUL_TMLS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
RUL_ID
OVD_ID |
OVT_OVD_FK_I | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OVD_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
RUL_ID | NUMBER | Yes | Foreign Key to OKC_RULES_B | |
SEQUENCE_NUMBER | NUMBER | (5) | Yes | Sequence number |
OVD_ID | NUMBER | Yes | Foreign key to table OKL_OPV_RULES | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
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
, RUL_ID
, SEQUENCE_NUMBER
, OVD_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM OKL.OKL_OVD_RUL_TMLS;
OKL.OKL_OVD_RUL_TMLS does not reference any database object
OKL.OKL_OVD_RUL_TMLS is referenced by following:
|
|
|