[Home] [Help]
[Dependency Information]
Object Name: | OKL_SIF_TRX_PARMS |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
Apart from the parameters which are captured during the booking process certain custom
parameters can be defined for the external pricing process. The values of such parameters for
each transaction are stored here. References to the custom pricing parameter headers, Stream
interface headers, contract headers and contracte lines are also stored here.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_SXP_U1 | NORMAL | UNIQUE |
![]() |
![]() |
OKL_SXP_U2 | NORMAL | UNIQUE |
![]() |
![]() ![]() ![]() ![]() |
SXP_KHR_FK_I | NORMAL | NONUNIQUE |
![]() |
![]() |
SXP_KLE_FK_I | NORMAL | NONUNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
INDEX_NUMBER1 | NUMBER | (5) | Sequence of the parameter value. | |
INDEX_NUMBER2 | NUMBER | (5) | For future use. | |
VALUE | VARCHAR2 | (240) | Yes | Parameter value. |
KHR_ID | NUMBER | Foreign key to table OKL_K_HEADERS | ||
KLE_ID | NUMBER | Foreign key to table OKL_K_LINES | ||
SIF_ID | NUMBER | Yes | Foreign key to table OKL_STREAM_INTERFACES | |
SPP_ID | NUMBER | Yes | Foreign key to table OKL_SIF_PRICE_PARMS | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | 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
, INDEX_NUMBER1
, INDEX_NUMBER2
, VALUE
, KHR_ID
, KLE_ID
, SIF_ID
, SPP_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM OKL.OKL_SIF_TRX_PARMS;
OKL.OKL_SIF_TRX_PARMS does not reference any database object
OKL.OKL_SIF_TRX_PARMS is referenced by following:
|
|
|