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

VIEW: APPS.OKL_CNTRCT_STRMS_SUM_UV

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

Fortign key to table OKL_K_HEADERS_FULL_V
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract Number to uniquely identify a contract
ACTIVITY_CODE VARCHAR2 (30) Yes Describes the state of the stream
ACTIVITY VARCHAR2 (4000)
User value of the state of the stream
NAME VARCHAR2 (150) Yes Stream type name
STREAM_TYPE_PURPOSE_CODE VARCHAR2 (30)
Stream Type Purpose Code
STREAM_TYPE_PURPOSE VARCHAR2 (4000)
Stream Type Purpose Meaning
PURPOSE_CODE VARCHAR2 (30)
Purpose of streams. Currently used for reporting.
PURPOSE VARCHAR2 (4000)
User value of purpose of the streams. Currently used for reporting.
AMOUNT NUMBER

Stream amount
ID NUMBER
Yes Stream Identifier
Query Text

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


SELECT KHR_ID
,      CONTRACT_NUMBER
,      ACTIVITY_CODE
,      ACTIVITY
,      NAME
,      STREAM_TYPE_PURPOSE_CODE
,      STREAM_TYPE_PURPOSE
,      PURPOSE_CODE
,      PURPOSE
,      AMOUNT
,      ID
FROM APPS.OKL_CNTRCT_STRMS_SUM_UV;

Dependencies

[top of page]

APPS.OKL_CNTRCT_STRMS_SUM_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_CNTRCT_STRMS_SUM_UV is not referenced by any database object