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

VIEW: APPS.OKL_STRM_TMPT_LINES_UV

Object Details
Object Name: OKL_STRM_TMPT_LINES_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_STRM_TMPT_LINES_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
PRIMARY_YN VARCHAR2 (3)
Primary Stream Type YN
PRIMARY_STY_ID NUMBER
Yes
PRIMARY_STY_NAME VARCHAR2 (150) Yes A unique name given for a type
PRIMARY_STY_PURPOSE VARCHAR2 (30)
Stream type purpose
DEPENDENT_STY_ID NUMBER

DEPENDENT_STY_NAME VARCHAR2 (150)
A unique name given for a type
DEPENDENT_STY_PURPOSE VARCHAR2 (30)
Stream type purpose
PRICING_NAME VARCHAR2 (150)
GTT_ID NUMBER
Yes Primary key column
VERSION VARCHAR2 (24) Yes Version
START_DATE DATE
Yes Start Date
END_DATE DATE

End Date
TMPT_STATUS VARCHAR2 (30) Yes Status of Template
GTS_ID NUMBER
Yes Primary key column
ST_GEN_TMPT_SET_NAME VARCHAR2 (150) Yes Name of the Stream template set
DESCRIPTION VARCHAR2 (1995)
User entered description for the stream template set
PRODUCT_TYPE VARCHAR2 (30) Yes Product Type. To indiacate if it is FINANCIAL or INVESTOR product.
TAX_OWNER VARCHAR2 (30) Yes Tax Ownership
DEAL_TYPE VARCHAR2 (30) Yes Book Classification
PRICING_ENGINE VARCHAR2 (30)
Pricing Engine to indicate if it is an internal or external
AES_ID NUMBER
Yes Primary key column
AE_TMPT_SET_NAME VARCHAR2 (150) Yes Primary key column
PDT_ID NUMBER
Yes Primary key column
PRODUCT_NAME VARCHAR2 (150) Yes Primary key column
Query Text

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


SELECT ID
,      PRIMARY_YN
,      PRIMARY_STY_ID
,      PRIMARY_STY_NAME
,      PRIMARY_STY_PURPOSE
,      DEPENDENT_STY_ID
,      DEPENDENT_STY_NAME
,      DEPENDENT_STY_PURPOSE
,      PRICING_NAME
,      GTT_ID
,      VERSION
,      START_DATE
,      END_DATE
,      TMPT_STATUS
,      GTS_ID
,      ST_GEN_TMPT_SET_NAME
,      DESCRIPTION
,      PRODUCT_TYPE
,      TAX_OWNER
,      DEAL_TYPE
,      PRICING_ENGINE
,      AES_ID
,      AE_TMPT_SET_NAME
,      PDT_ID
,      PRODUCT_NAME
FROM APPS.OKL_STRM_TMPT_LINES_UV;

Dependencies

[top of page]

APPS.OKL_STRM_TMPT_LINES_UV references the following:

SchemaAPPS
SynonymOKL_AE_TMPT_SETS_ALL
ViewOKL_PRODUCTS_V
SynonymOKL_STRM_TYPE_B
SynonymOKL_STRM_TYPE_TL
SynonymOKL_ST_GEN_TEMPLATES_ALL
SynonymOKL_ST_GEN_TMPT_LNS_ALL
SynonymOKL_ST_GEN_TMPT_SETS_ALL
APPS.OKL_STRM_TMPT_LINES_UV is referenced by following:

SchemaAPPS
Package BodyOKL_AUTO_INSURANCE_PVT - show dependent code
Package BodyOKL_INS_QUOTE_PVT - show dependent code
Package BodyOKL_LA_STREAM_PVT - show dependent code
Package BodyOKL_MULTIGAAP_ENGINE_PVT - show dependent code
Package BodyOKL_PRICING_UTILS_PVT - show dependent code
Package BodyOKL_QA_DATA_INTEGRITY - show dependent code
PL/SQL PackageOKL_QA_DATA_INTEGRITY - show dependent code
Package BodyOKL_SEEDED_FUNCTIONS_PVT - show dependent code
Package BodyOKL_STREAMS_UTIL - show dependent code