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

VIEW: APPS.OKL_POOL_STREAMS_UV

Object Details
Object Name: OKL_POOL_STREAMS_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_POOL_STREAMS_UV
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
KHR_ID NUMBER

Pool contract header identifier
KLE_ID NUMBER

Pool financial asset line identifier
STY_ID NUMBER
Yes Stream type identifier
STREAM_TYPE_CODE VARCHAR2 (150) Yes Stream type code
STREAM_TYPE_NAME VARCHAR2 (150) Yes Stream type name
STREAM_TYPE_SUBCLASS VARCHAR2 (30)
Stream type subclass
STREAM_SAY_CODE VARCHAR2 (30) Yes Stream status code
STREAM_ACTIVE_YN VARCHAR2 (3) Yes Stream active falg. Indicates whether stream is active or not
STREAM_ELEMENT_DUE_DATE DATE
Yes Date on which stream element is due
STREAM_ELEMENT_AMOUNT NUMBER
Yes Stream element amount
STREAM_ELEMENT_DATE_BILLED DATE

Date on which stream element amount is billed
STM_ID NUMBER
Yes Unique identifier for streams
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT KHR_ID
,      KLE_ID
,      STY_ID
,      STREAM_TYPE_CODE
,      STREAM_TYPE_NAME
,      STREAM_TYPE_SUBCLASS
,      STREAM_SAY_CODE
,      STREAM_ACTIVE_YN
,      STREAM_ELEMENT_DUE_DATE
,      STREAM_ELEMENT_AMOUNT
,      STREAM_ELEMENT_DATE_BILLED
,      STM_ID
FROM APPS.OKL_POOL_STREAMS_UV;

Dependencies

[top of page]

APPS.OKL_POOL_STREAMS_UV references the following:

SchemaAPPS
PL/SQL PackageOKL_ACCOUNTING_UTIL - show dependent code
SynonymOKL_STREAMS
SynonymOKL_STRM_ELEMENTS
ViewOKL_STRM_TYPE_V
APPS.OKL_POOL_STREAMS_UV is referenced by following:

SchemaAPPS
Package BodyOKL_POOL_PVT - show dependent code
ViewOKL_POOL_SRCH_V