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

VIEW: APPS.OKL_STRM_TMPT_FULL_UV

Object Details
Object Name: OKL_STRM_TMPT_FULL_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_STRM_TMPT_FULL_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
PRIMARY_YN VARCHAR2 (3)
Primary Stream Type YN
STY_ID NUMBER

Stream Type Identifier
STY_NAME VARCHAR2 (150)
A unique name given for a type
STY_PURPOSE VARCHAR2 (30)
Stream type purpose
STY_PURPOSE_MEANING VARCHAR2 (4000)
Stream type purpose meaning
BILLABLE_YN VARCHAR2 (30)
Billable YN
CAPITALIZE_YN VARCHAR2 (30)
Capitalize YN
PRICING_NAME VARCHAR2 (150)
Pricing Name
GTT_ID NUMBER

Stream template identifier
VERSION VARCHAR2 (24)
Stream template version
START_DATE DATE

Start date
END_DATE DATE

End Date
TMPT_STATUS VARCHAR2 (30)
Template status
GTS_ID NUMBER

Template set identifier
ST_GEN_TMPT_SET_NAME VARCHAR2 (150)
Stream template set name
DESCRIPTION VARCHAR2 (1995)
Description
PRODUCT_TYPE VARCHAR2 (30)
Product Type
TAX_OWNER VARCHAR2 (30)
Tax owner
DEAL_TYPE VARCHAR2 (30)
Book classification
PRICING_ENGINE VARCHAR2 (30)
Pricing engine
AES_ID NUMBER

Accounting Template set Id
AE_TMPT_SET_NAME VARCHAR2 (150)
Accounting Template set name
PDT_ID NUMBER

Product Id
PRODUCT_NAME VARCHAR2 (150)
Product Name
PRIMARY_STY_ID NUMBER

This field will have the primary stream id corresponding to the depdendent stream defined by sty_id
Query Text

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


SELECT ID
,      PRIMARY_YN
,      STY_ID
,      STY_NAME
,      STY_PURPOSE
,      STY_PURPOSE_MEANING
,      BILLABLE_YN
,      CAPITALIZE_YN
,      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
,      PRIMARY_STY_ID
FROM APPS.OKL_STRM_TMPT_FULL_UV;

Dependencies

[top of page]

APPS.OKL_STRM_TMPT_FULL_UV references the following:

SchemaAPPS
PL/SQL PackageOKL_ACCOUNTING_UTIL - show dependent code
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_FULL_UV is referenced by following:

SchemaAPPS
Package BodyOKL_CONTRACT_TOP_LINE_PVT - show dependent code
ViewOKL_LA_PT_EVG_STRM_TYPE_UV
Package BodyOKL_MAINTAIN_FEE_PVT - show dependent code
Package BodyOKL_STREAMS_UTIL - show dependent code
Package BodyOKL_TIL_PVT - show dependent code