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

VIEW: APPS.OKL_STRM_TMPT_CONTRACTS_UV

Object Details
Object Name: OKL_STRM_TMPT_CONTRACTS_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_STRM_TMPT_CONTRACTS_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
STY_ID NUMBER

Stream Type Identifier
STY_NAME VARCHAR2 (150)
Stream type
STY_PURPOSE VARCHAR2 (30)
Stream type purpose code
STY_PURPOSE_MEANING VARCHAR2 (4000)
Stream Type Purpose
GTS_ID NUMBER

Stream Template set identifier
ST_GEN_TMPT_SET_NAME VARCHAR2 (150)
Stream Template set name
AES_ID NUMBER

Accounting Template set identifier
AE_TMPT_SET_NAME VARCHAR2 (150)
Accounting Template Set Name
PDT_ID NUMBER

Product Identifier
PRODUCT_NAME VARCHAR2 (150)
Product Name
KHR_ID NUMBER

Contract Identifier
CONTRACT_NUMBER VARCHAR2 (120)
Contract Number
Query Text

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


SELECT STY_ID
,      STY_NAME
,      STY_PURPOSE
,      STY_PURPOSE_MEANING
,      GTS_ID
,      ST_GEN_TMPT_SET_NAME
,      AES_ID
,      AE_TMPT_SET_NAME
,      PDT_ID
,      PRODUCT_NAME
,      KHR_ID
,      CONTRACT_NUMBER
FROM APPS.OKL_STRM_TMPT_CONTRACTS_UV;

Dependencies

[top of page]

APPS.OKL_STRM_TMPT_CONTRACTS_UV references the following:

SchemaAPPS
SynonymOKC_K_HEADERS_ALL_B
PL/SQL PackageOKL_ACCOUNTING_UTIL - show dependent code
SynonymOKL_AE_TMPT_SETS_ALL
SynonymOKL_K_HEADERS
ViewOKL_PRODUCTS_V
ViewOKL_STRM_TYPE_V
SynonymOKL_ST_GEN_TEMPLATES_ALL
SynonymOKL_ST_GEN_TMPT_LNS_ALL
SynonymOKL_ST_GEN_TMPT_SETS_ALL

APPS.OKL_STRM_TMPT_CONTRACTS_UV is not referenced by any database object