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

VIEW: APPS.OKL_PDT_PQY_VALS_UV

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

Primary key column
PDT_ID NUMBER

Foreign key to view OKL_PRODUCTS_V
PDQ_ID NUMBER

Foreign key to view OKL_PDT_PQYS_V
PQY_ID NUMBER

Foreign key to view OKL_PDT_QUALITYS_V
NAME VARCHAR2 (150)
Name
VALUE VARCHAR2 (150)
This is the value for quality value.
DESCRIPTION VARCHAR2 (1995)
OBJECT_VERSION_NUMBER NUMBER

Column used for locking records during updates
FROM_DATE DATE

From Date
TO_DATE DATE

To Date
Query Text

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


SELECT ID
,      PDT_ID
,      PDQ_ID
,      PQY_ID
,      NAME
,      VALUE
,      DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      FROM_DATE
,      TO_DATE
FROM APPS.OKL_PDT_PQY_VALS_UV;

Dependencies

[top of page]

APPS.OKL_PDT_PQY_VALS_UV references the following:

SchemaAPPS
SynonymOKL_PDT_PQYS
SynonymOKL_PDT_PQY_VALS
SynonymOKL_PDT_QUALITYS
SynonymOKL_PQY_VALUES
SynonymOKL_PRODUCTS
APPS.OKL_PDT_PQY_VALS_UV is referenced by following:

SchemaAPPS
Package BodyOKL_LA_STREAM_PVT - show dependent code
Package BodyOKL_STREAM_MIGRATION_PVT - show dependent code