[Home] [Help] [Dependency Information]
Object Name: | OKL_STREAMS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_STREAMS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Auto-generated by Headstart Utilities | |
ID | NUMBER | Yes | Primary key column | |
TRANSACTION_NUMBER | NUMBER | Transaction Number | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
SGN_CODE | VARCHAR2 | (30) | Yes | the source of the STREAM |
SAY_CODE | VARCHAR2 | (30) | Yes | Describes the state of the stream |
STY_ID | NUMBER | Yes | Foreign key to table OKL_STRM_TYPE_B | |
KLE_ID | NUMBER | Foreign key to table OKL_K_LINES | ||
KHR_ID | NUMBER | Foreign key to table OKL_K_HEADERS | ||
ACTIVE_YN | VARCHAR2 | (3) | Yes | Whether the STREAM is active or inactive |
PURPOSE_CODE | VARCHAR2 | (30) | Purpose of streams. Currently used for reporting. | |
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 | |
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 | |
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 | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
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 ROW_ID
, ID
, TRANSACTION_NUMBER
, OBJECT_VERSION_NUMBER
, SGN_CODE
, SAY_CODE
, STY_ID
, KLE_ID
, KHR_ID
, ACTIVE_YN
, PURPOSE_CODE
, DATE_CURRENT
, DATE_WORKING
, DATE_HISTORY
, COMMENTS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, PROGRAM_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, LAST_UPDATE_LOGIN
, STM_ID
, SOURCE_ID
, SOURCE_TABLE
, TRX_ID
, LINK_HIST_STREAM_ID
FROM APPS.OKL_STREAMS_V;
|
|
|