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

VIEW: APPS.OKL_ASST_STRMS_SUM_UV

Object Details
Object Name: OKL_ASST_STRMS_SUM_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_ASST_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
CONTRACT_ID NUMBER
Yes Unique Contract Identification number
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract Number
ACTIVITY_CODE VARCHAR2 (30) Yes Describes 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
LINE_NAME VARCHAR2 (150)
Contract Line item name
AMOUNT NUMBER

Stream amount
ACTIVITY VARCHAR2 (4000)
Describes the state of the stream
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.
ID NUMBER
Yes Stream Identifier
Query Text

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


SELECT CONTRACT_ID
,      CONTRACT_NUMBER
,      ACTIVITY_CODE
,      NAME
,      STREAM_TYPE_PURPOSE_CODE
,      STREAM_TYPE_PURPOSE
,      LINE_NAME
,      AMOUNT
,      ACTIVITY
,      PURPOSE_CODE
,      PURPOSE
,      ID
FROM APPS.OKL_ASST_STRMS_SUM_UV;

Dependencies

[top of page]

APPS.OKL_ASST_STRMS_SUM_UV references the following:

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

APPS.OKL_ASST_STRMS_SUM_UV is not referenced by any database object