eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKL_STRM_TMPT_PRC_PARAMS_UV

Object Details

Object Name:	OKL_STRM_TMPT_PRC_PARAMS_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_STRM_TMPT_PRC_PARAMS_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	Pricing Parameter Name
PARAMETER_DESC	VARCHAR2	(1995)		Pricing Parameter Description
DISPLAY_YN	VARCHAR2	(3)		Pricing Parameter Display YN
UPDATE_YN	VARCHAR2	(3)		Pricing Parameter Update YN
PRC_ENG_IDENT	VARCHAR2	(450)	Yes	Pricing Engine Identifier
VALUE	CHAR	(0)		value
DEFAULT_VALUE	VARCHAR2	(450)	Yes	Default value
GTT_ID	NUMBER		Yes	Stream Template set identifier
VERSION	VARCHAR2	(24)	Yes	version
START_DATE	DATE		Yes	start date
END_DATE	DATE			end date
TMPT_STATUS	VARCHAR2	(30)	Yes	Template status
GTS_ID	NUMBER		Yes	Template set identifier
ST_GEN_TMPT_SET_NAME	VARCHAR2	(150)	Yes	Stream template set name
DESCRIPTION	VARCHAR2	(1995)		Description
PRODUCT_TYPE	VARCHAR2	(30)	Yes	Product type
TAX_OWNER	VARCHAR2	(30)	Yes	Tax owner
DEAL_TYPE	VARCHAR2	(30)	Yes	Book classification
PRICING_ENGINE	VARCHAR2	(30)		Pricing engine
AES_ID	NUMBER		Yes	Accounting Template set identifier
AE_TMPT_SET_NAME	VARCHAR2	(150)	Yes	Accounting Template set name
PDT_ID	NUMBER		Yes	Product Id
PRODUCT_NAME	VARCHAR2	(150)	Yes	Product Name
KHR_ID	NUMBER		Yes	Contract Id

Query Text

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


SELECT ID
,      NAME
,      PARAMETER_DESC
,      DISPLAY_YN
,      UPDATE_YN
,      PRC_ENG_IDENT
,      VALUE
,      DEFAULT_VALUE
,      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
,      KHR_ID
FROM APPS.OKL_STRM_TMPT_PRC_PARAMS_UV;

Dependencies

[top of page]

APPS.OKL_STRM_TMPT_PRC_PARAMS_UV references the following:

APPS: OKC_K_HEADERS_ALL_B; OKL_AE_TMPT_SETS_ALL; OKL_K_HEADERS; OKL_PRODUCTS_V; OKL_ST_GEN_PRC_PRMS_ALL; OKL_ST_GEN_TEMPLATES_ALL; OKL_ST_GEN_TMPT_SETS_ALL

APPS.OKL_STRM_TMPT_PRC_PARAMS_UV is not referenced by any database object