[Home] [Help] [Dependency Information]
Object Name: | OKL_STREAMS |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_STREAMS |
Subobject Name: | |
Status: | VALID |
The payment header details for a contract or an asset are stored here. The streams status is also
stored in this table e.g. WORKING, HISTORY, CURRENT. References to stream type, contract and
asset are also stored here.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_STM_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKL_STM_U3 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
STY_ID
KHR_ID TRANSACTION_NUMBER KLE_ID |
STM_KHR_FK_I | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | KHR_ID |
STM_KLE_FK_I | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | KLE_ID |
STM_SRC_FK_2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_TABLE |
STM_SRC_FK_I | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
TRANSACTION_NUMBER | NUMBER | Transaction Number | ||
STY_ID | NUMBER | Yes | Foreign key to table OKL_STRM_TYPE_B | |
KHR_ID | NUMBER | Foreign key to table OKL_K_HEADERS | ||
KLE_ID | NUMBER | Foreign key to table OKL_K_LINES | ||
SGN_CODE | VARCHAR2 | (30) | Yes | the source of the STREAM |
SAY_CODE | VARCHAR2 | (30) | Yes | Describes the state of the stream |
ACTIVE_YN | VARCHAR2 | (3) | Yes | Whether the STREAM is active or inactive |
DATE_CURRENT | DATE | Dateime of current stream | ||
DATE_WORKING | DATE | datetime of working stream | ||
DATE_HISTORY | DATE | datetime history of stream | ||
COMMENTS | VARCHAR2 | (1995) | User entered comments | |
PROGRAM_ID | NUMBER | (15) | Concurrent Manager column | |
REQUEST_ID | NUMBER | (15) | Concurrent Manager column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Manager column | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Manager column | ||
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 | |
PURPOSE_CODE | VARCHAR2 | (30) | Purpose of streams. Currently used for reporting. | |
STM_ID | NUMBER | Stream Identifier | ||
SOURCE_ID | NUMBER | Source Identifier | ||
SOURCE_TABLE | VARCHAR2 | (30) | Source Table Name | |
TRX_ID | NUMBER | Transaction Identifier | ||
LINK_HIST_STREAM_ID | NUMBER | Link to Streams History |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, OBJECT_VERSION_NUMBER
, TRANSACTION_NUMBER
, STY_ID
, KHR_ID
, KLE_ID
, SGN_CODE
, SAY_CODE
, ACTIVE_YN
, DATE_CURRENT
, DATE_WORKING
, DATE_HISTORY
, COMMENTS
, PROGRAM_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PURPOSE_CODE
, STM_ID
, SOURCE_ID
, SOURCE_TABLE
, TRX_ID
, LINK_HIST_STREAM_ID
FROM OKL.OKL_STREAMS;
OKL.OKL_STREAMS does not reference any database object
OKL.OKL_STREAMS is referenced by following:
|
|
|