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

VIEW: APPS.OKL_PROD_STRM_TYPES_UV

Object Details
Object Name: OKL_PROD_STRM_TYPES_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_PROD_STRM_TYPES_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
ID NUMBER
Yes Primary key column
ACCRUAL_YN VARCHAR2 (3) Yes Yes or No
ACCRUAL_YN_MEANING VARCHAR2 (4000)
Returns the meaning of Accrual Flag
NAME VARCHAR2 (150) Yes Name
START_DATE DATE
Yes Start Date
END_DATE DATE

End Date
PDT_ID NUMBER
Yes Foreign key to view OKL_PRODUCTS_V
STY_ID NUMBER
Yes Foreign key to view OKL_STRM_TYPE_V
FROM_DATE DATE
Yes From Date
TO_DATE DATE

To Date
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
PURPOSE VARCHAR2 (80) Yes Stream Type Purpose
Query Text

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


SELECT ID
,      ACCRUAL_YN
,      ACCRUAL_YN_MEANING
,      NAME
,      START_DATE
,      END_DATE
,      PDT_ID
,      STY_ID
,      FROM_DATE
,      TO_DATE
,      OBJECT_VERSION_NUMBER
,      PURPOSE
FROM APPS.OKL_PROD_STRM_TYPES_UV;

Dependencies

[top of page]

APPS.OKL_PROD_STRM_TYPES_UV references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
PL/SQL PackageOKL_ACCOUNTING_UTIL - show dependent code
SynonymOKL_PROD_STRM_TYPES
SynonymOKL_STRM_TYPE_B
SynonymOKL_STRM_TYPE_TL

APPS.OKL_PROD_STRM_TYPES_UV is not referenced by any database object