[Home] [Help] [Dependency Information]
Object Name: | OKL_STREAM_TRX_DATA |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_STREAM_TRX_DATA |
Subobject Name: | |
Status: | VALID |
Data in the form of XML is used for transactions with the external pricing engine. The XML returned
by the pricing engine is stored here. Once the transaction is complete the data pertaining to the
transaction is purged from this table. Reference to stream interface headers are also stored here.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_STREAM_TRX_DATA_U1 | NORMAL | UNIQUE | APPS_TS_NOLOGGING | ID |
SYS_IL0000202087C00005$$ | LOB | UNIQUE | APPS_TS_NOLOGGING | |
SYS_IL0000202087C00006$$ | LOB | UNIQUE | APPS_TS_NOLOGGING | |
STD_SIF_FK_I | NORMAL | NONUNIQUE | APPS_TS_NOLOGGING | SIF_ID |
STD_SIR_FK_I | NORMAL | NONUNIQUE | APPS_TS_NOLOGGING | SIR_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
SIF_ID | NUMBER | Foreign key to table OKL_STREAM_INTERFACES | ||
SIR_ID | NUMBER | Foreign key to table OKL_SIF_RETS | ||
TRANSACTION_NUMBER | NUMBER | Unique identifier for the transaction. | ||
OUT_XML | CLOB | (4000) | Outbound XML data that is sent to the external pricing engine. | |
IN_XML | CLOB | (4000) | Inbound XML data that is received from the external pricing engine. | |
COMMENTS | VARCHAR2 | (1995) | User entered comments | |
STATUS | VARCHAR2 | (30) | Status |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, SIF_ID
, SIR_ID
, TRANSACTION_NUMBER
, OUT_XML
, IN_XML
, COMMENTS
, STATUS
FROM OKL.OKL_STREAM_TRX_DATA;
OKL.OKL_STREAM_TRX_DATA does not reference any database object
OKL.OKL_STREAM_TRX_DATA is referenced by following:
|
|
|