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

VIEW: APPS.OKL_STREAMS_V

Object Details
Object Name: OKL_STREAMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_STREAMS_V
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) 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
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
FROM APPS.OKL_STREAMS_V;

Dependencies

[top of page]

APPS.OKL_STREAMS_V references the following:

SchemaAPPS
SynonymOKL_STREAMS
APPS.OKL_STREAMS_V is referenced by following:

SchemaAPPS
Package BodyOKL_AM_CNTRCT_LN_TRMNT_PVT - show dependent code
Package BodyOKL_AM_LEASE_TRMNT_PVT - show dependent code
Package BodyOKL_AM_SECURITIZATION_PVT - show dependent code
Package BodyOKL_AM_TERMNT_QUOTE_PVT - show dependent code
Package BodyOKL_AM_VENDOR_RES_SHARE_PVT - show dependent code
Package BodyOKL_BILL_STATUS_PVT - show dependent code
ViewOKL_BPD_AP_DISB_DTL_LN_UV
Package BodyOKL_CONTRACT_BOOK_PVT - show dependent code
Package BodyOKL_CONTRACT_INFO - show dependent code
ViewOKL_CS_TAX_SUMMARY_UV
Package BodyOKL_DAILY_INTEREST_CALC_PVT - show dependent code
Package BodyOKL_EVERGREEN_BILLING_PVT - show dependent code
PL/SQL PackageOKL_GENERATE_ACCRUALS_PVT - show dependent code
Package BodyOKL_INS_QUOTE_PVT - show dependent code
ViewOKL_KLE_STRM_V
Package BodyOKL_LTE_CHRG_PVT - show dependent code
Package BodyOKL_LTE_INT_PVT - show dependent code
Package BodyOKL_PROCESS_STREAMS_PVT - show dependent code
Package BodyOKL_SEL_PVT - show dependent code
Package BodyOKL_STM_PVT - show dependent code
PL/SQL PackageOKL_STM_PVT - show dependent code
ViewOKL_TAX_LINES_UV
Package BodyOKL_UBB_PVT - show dependent code
Package BodyOKL_VARIABLE_INTEREST_PVT - show dependent code
Package BodyOKL_VARIABLE_INT_UTIL_PVT - show dependent code
Package BodyOKL_VAR_INT_CATCHUP_PVT - show dependent code
Package BodyOKL_VAR_INT_FLOAT_PVT - show dependent code