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

VIEW: APPS.OKL_CONTRACT_STREAMS_UV

Object Details
Object Name: OKL_CONTRACT_STREAMS_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CONTRACT_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

Foreign key to view OKL_K_HEADERS_V
NAME VARCHAR2 (150) Yes Name
STREAM_TYPE_PURPOSE_CODE VARCHAR2 (30)
Stream Type Purpose Code
STREAM_TYPE_PURPOSE VARCHAR2 (4000)
Stream Type Purpose Meaning
STREAM_ELEMENT_DATE DATE
Yes The inclusive start date of the period of time between actions
AMOUNT NUMBER
Yes Amount
ACTIVITY_CODE VARCHAR2 (30) Yes Describes the state of the stream
ACTIVITY VARCHAR2 (4000)
TRANSACTION_NUMBER NUMBER

PURPOSE_CODE VARCHAR2 (30)
PURPOSE VARCHAR2 (4000)
SHORT_DESCRIPTION VARCHAR2 (600)
ID NUMBER
Yes Stream Identifier
Query Text

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


SELECT KHR_ID
,      NAME
,      STREAM_TYPE_PURPOSE_CODE
,      STREAM_TYPE_PURPOSE
,      STREAM_ELEMENT_DATE
,      AMOUNT
,      ACTIVITY_CODE
,      ACTIVITY
,      TRANSACTION_NUMBER
,      PURPOSE_CODE
,      PURPOSE
,      SHORT_DESCRIPTION
,      ID
FROM APPS.OKL_CONTRACT_STREAMS_UV;

Dependencies

[top of page]

APPS.OKL_CONTRACT_STREAMS_UV references the following:

SchemaAPPS
SynonymOKC_K_HEADERS_B
PL/SQL PackageOKL_ACCOUNTING_UTIL - show dependent code
SynonymOKL_STREAMS
SynonymOKL_STRM_ELEMENTS
SynonymOKL_STRM_TYPE_B
SynonymOKL_STRM_TYPE_TL

APPS.OKL_CONTRACT_STREAMS_UV is not referenced by any database object