[Home] [Help]
[Dependency Information]
Object Name: | OKL_STREAM_TRX_DATA# |
---|---|
Object Type: | VIEW |
Owner: | OKL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | ||
SIF_ID | NUMBER | |||
SIR_ID | NUMBER | |||
TRANSACTION_NUMBER | NUMBER | |||
OUT_XML | CLOB | (4000) | ||
IN_XML | CLOB | (4000) | ||
COMMENTS | VARCHAR2 | (1995) | ||
STATUS | VARCHAR2 | (30) | ||
TRANSACTION_STATE | CLOB | (4000) | ||
KHR_ID | NUMBER | |||
ORIG_KHR_ID | NUMBER | |||
LAST_TRX_STATE | VARCHAR2 | (1) | ||
TRX_REFERENCE | NUMBER |
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
, TRANSACTION_STATE
, KHR_ID
, ORIG_KHR_ID
, LAST_TRX_STATE
, TRX_REFERENCE
FROM OKL.OKL_STREAM_TRX_DATA#;
|
|
|