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.XTR_PRODUCT_TYPES_V

Object Details

Object Name:	XTR_PRODUCT_TYPES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_PRODUCT_TYPES_V
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
DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
PRODUCT_TYPE	VARCHAR2	(10)	Yes	Code for products used in a deal type
PRODUCT_DESC	VARCHAR2	(80)	Yes	Product description
PRODUCT_AUTH	VARCHAR2	(1)	Yes	Flag to indicate if the product is authorized (Y), or not (N)
CALC_BASIS	VARCHAR2	(8)		Basis on which deduction is calculated
UPDATED_BY	VARCHAR2	(30)		User who last updated this record
UPDATED_ON	DATE			Date this record was last updated
AUDIT_INDICATOR	VARCHAR2	(1)		Not currently used
CPARTY_ADVICE	VARCHAR2	(1)		Not currently used
CLIENT_ADVICE	VARCHAR2	(1)		Not currently used
REVAL_CROSS_REF	VARCHAR2	(20)		Not currently used
DEFAULT_PRICING_MODEL	VARCHAR2	(30)		Default pricing model for this product type. Derived from the CODE column of the XTR_PRICE_MODELS table.
DEFAULT_MARKET_DATA_SET	VARCHAR2	(30)		Specifies the Market Data Set to be used with the Default Pricing Model for revaluation.
DEFAULT_MARGIN	NUMBER			Specifies the default margin for revaluation. This column is relevant for Bonds, Bond Options, Discounted Securities and Wholesale Term Money.
ALLOW_REVAL_OVERWRITE_FLAG	VARCHAR2	(1)	Yes	Specifies if the fair value of the deal calculated using this pricing model under the associated deal type can be overridden at the revaluation details level. Y=Allows overwrite. Y=Denies overwrite.
CREATED_BY	VARCHAR2	(30)	Yes	User who created this record
CREATED_ON	DATE		Yes	Date this record was created

Query Text

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


SELECT DEAL_TYPE
,      PRODUCT_TYPE
,      PRODUCT_DESC
,      PRODUCT_AUTH
,      CALC_BASIS
,      UPDATED_BY
,      UPDATED_ON
,      AUDIT_INDICATOR
,      CPARTY_ADVICE
,      CLIENT_ADVICE
,      REVAL_CROSS_REF
,      DEFAULT_PRICING_MODEL
,      DEFAULT_MARKET_DATA_SET
,      DEFAULT_MARGIN
,      ALLOW_REVAL_OVERWRITE_FLAG
,      CREATED_BY
,      CREATED_ON
FROM APPS.XTR_PRODUCT_TYPES_V;

Dependencies

[top of page]

APPS.XTR_PRODUCT_TYPES_V references the following:

APPS: XTR_PRODUCT_TYPES

APPS.XTR_PRODUCT_TYPES_V is referenced by following:

APPS: XTR_AUTH_PRODUCT_TYPES_V; XTR_HEDGE_PRODUCT_TYPES_V; XTR_IG_TRANSFERS_PKG - show dependent code; XTR_NI_TRANSFERS_PKG - show dependent code