[Home] [Help] [Dependency Information]
Object Name: | OKL_STREAM_TRX_DATA_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_STREAM_TRX_DATA_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier in the database | |
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 ROW_ID
, ID
, SIF_ID
, SIR_ID
, TRANSACTION_NUMBER
, OUT_XML
, IN_XML
, COMMENTS
, STATUS
FROM APPS.OKL_STREAM_TRX_DATA_V;
APPS.OKL_STREAM_TRX_DATA_V is not referenced by any database object
|
|
|