DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKL_STREAMS_REP_V

Object Details
Object Name: OKL_STREAMS_REP_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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)
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
REPO_FLAG VARCHAR2 (1)
Source Table Name
Query Text

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
,      REPO_FLAG
FROM APPS.OKL_STREAMS_REP_V;

Dependencies

[top of page]

APPS.OKL_STREAMS_REP_V references the following:

SchemaAPPS
SynonymOKL_STREAMS
APPS.OKL_STREAMS_REP_V is referenced by following:

SchemaAPPS
Package BodyOKL_ACCRUAL_SEC_PVT - show dependent code
Package BodyOKL_CONTRACT_REBOOK_PVT - show dependent code
Package BodyOKL_GENERATE_ACCRUALS_PVT - show dependent code
Package BodyOKL_INSURANCE_POLICIES_PVT - show dependent code
Package BodyOKL_REPORT_GENERATOR_PVT - show dependent code
Package BodyOKL_SEEDED_FUNCTIONS_PVT - show dependent code