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]

TABLE: XTR.XTR_PRODUCT_TYPES

Object Details

Object Name:	XTR_PRODUCT_TYPES
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_PRODUCT_TYPES
Subobject Name:
Status:	VALID

XTR_PRODUCT_TYPES contains the user-defined product types. Product types are used to identify a specific product within a deal type. Each row corresponds to one product type and its corresponding deal type. Each deal type must exist in the XTR_DEAL_TYPES table. A deal type may have many product types. A product type can also be associated to many deal types.
This table correspond to the DEAL TYPE/PROUDCT TYPES window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_PRODUCT_TYPES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEAL_TYPE PRODUCT_TYPE
XTR_PRODUCT_TYPES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEFAULT_PRICING_MODEL

Columns

Name	Datatype	Length	Mandatory	Comments
AUDIT_INDICATOR	VARCHAR2	(1)		Not currently used
CALC_BASIS	VARCHAR2	(8)		Basis on which deduction is calculated
CLIENT_ADVICE	VARCHAR2	(1)		Not currently used
CPARTY_ADVICE	VARCHAR2	(1)		Not currently used
DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
PRODUCT_AUTH	VARCHAR2	(1)	Yes	Flag to indicate if the product is authorized (Y), or not (N)
PRODUCT_TYPE	VARCHAR2	(10)	Yes	Code for products used in a deal type
PRODUCT_DESC	VARCHAR2	(80)	Yes	Product description
REVAL_CROSS_REF	VARCHAR2	(20)		Not currently used
UPDATED_BY	VARCHAR2	(30)		User who last updated this record
UPDATED_ON	DATE			Date this record was last updated
CREATED_BY	VARCHAR2	(30)	Yes	User who created this record
CREATED_ON	DATE		Yes	Date this record was created
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.

Query Text

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


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

Dependencies

[top of page]

XTR.XTR_PRODUCT_TYPES does not reference any database object

XTR.XTR_PRODUCT_TYPES is referenced by following:

APPS: XTR_AU_PRODUCT_TYPES_T; XTR_PRODUCT_TYPES