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

VIEW: APPS.OKL_REPORTING_PRODUCTS_UV

Object Details
Object Name: OKL_REPORTING_PRODUCTS_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_REPORTING_PRODUCTS_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
NAME VARCHAR2 (150) Yes Name of the reporting product
PTL_ID NUMBER

Foreign key to table OKL_PDT_TEMPLATES
VERSION VARCHAR2 (24) Yes Version of the product
DESCTIPTION VARCHAR2 (1995)
Description for a product
FROM_DATE DATE
Yes From Date for a reporting product
TO_DATE DATE

To Date for a reporting product
AES_ID NUMBER
Yes Foreign key to table OKL_AE_TMPT_SETS
OBJECT_VERSION_NUMBER NUMBER (9) Yes Object version number
LEGACY_PRODUCT_YN VARCHAR2 (3) Yes Flag to indicate if the product is a legacy product or not
REPORTING_PDT_ID NUMBER

Reporting Product Identifier
REPORTING_PRODUCT VARCHAR2 (150)
Reporting Product Name
Query Text

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


SELECT ID
,      NAME
,      PTL_ID
,      VERSION
,      DESCTIPTION
,      FROM_DATE
,      TO_DATE
,      AES_ID
,      OBJECT_VERSION_NUMBER
,      LEGACY_PRODUCT_YN
,      REPORTING_PDT_ID
,      REPORTING_PRODUCT
FROM APPS.OKL_REPORTING_PRODUCTS_UV;

Dependencies

[top of page]

APPS.OKL_REPORTING_PRODUCTS_UV references the following:

SchemaAPPS
SynonymOKL_AE_TMPT_SETS
SynonymOKL_PDT_PQY_VALS
SynonymOKL_PDT_QUALITYS
SynonymOKL_PQY_VALUES
ViewOKL_PQY_VALUES_V
SynonymOKL_PRODUCTS

APPS.OKL_REPORTING_PRODUCTS_UV is not referenced by any database object