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_DEAL_SUBTYPES

Object Details

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

XTR_DEAL_SUBTYPES contains deal subtypes information. Each row in this table corresponds to a deal type, deal subtype combination and the tolerance level for that combination. The deal type must exist in the XTR_DEAL_TYPES table. Each deal transaction must be associated with a deal subtype that belongs to the deal type of your deal transaction.
This table corresponds to the Deal Subtypes tabbed region in the Deal Types/Product Types window.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_DEAL_SUBTYPES_U1	NORMAL	UNIQUE	APPS_TS_SEED	DEAL_TYPE DEAL_SUBTYPE ZD_EDITION_NAME
XTR_DEAL_SUBTYPES_U2	NORMAL	UNIQUE	APPS_TS_SEED	DEAL_TYPE USER_DEAL_SUBTYPE ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
AUTHORISED	VARCHAR2	(1)		Flag to indicate if the deal subtype is authorized for use (Y), or not (N)
DEAL_SUBTYPE	VARCHAR2	(7)	Yes	Code for deal executions permissible within a deal type
USER_DEAL_SUBTYPE	VARCHAR2	(7)	Yes	User-defined deal subtype code
DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
LIMIT_WEIGHTING	NUMBER			Percentage of a deal's face value considered as risk
NAME	VARCHAR2	(80)	Yes	Deal subtype name
PRICE_ROUNDING	NUMBER			Not currently used
TOLERANCE	NUMBER			Tolerence level (as a percentage)
YIELD_ROUNDING	NUMBER			Not currently used
SEEDED_DESCRIPTION	VARCHAR2	(80)	Yes	Pre-defined deal subtype description
UPDATED_BY	VARCHAR2	(30)		User who last updated this record
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT AUTHORISED
,      DEAL_SUBTYPE
,      USER_DEAL_SUBTYPE
,      DEAL_TYPE
,      LIMIT_WEIGHTING
,      NAME
,      PRICE_ROUNDING
,      TOLERANCE
,      YIELD_ROUNDING
,      SEEDED_DESCRIPTION
,      UPDATED_BY
,      ZD_EDITION_NAME
FROM XTR.XTR_DEAL_SUBTYPES;

Dependencies

[top of page]

XTR.XTR_DEAL_SUBTYPES does not reference any database object

XTR.XTR_DEAL_SUBTYPES is referenced by following:

XTR: XTR_DEAL_SUBTYPES#