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_DISC_DEALS_TRANSACTIONS_V

Object Details

Object Name:	XTR_DISC_DEALS_TRANSACTIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_DISC_DEALS_TRANSACTIONS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

The XTR_DISC_DEALS_TRANSACTIONS_V view contains information about the deals in the Oracle Treasury database and is similar to the QRM_CURRENT_DEALS_V view. The XTR_DISC_DEALS_TRANSACTIONS_V view contains current deals as well as deals with status other than cancelled.

[View Source]

Columns

Name	Datatype	Length	Comments
DEAL_NO	NUMBER		Unique number assigned to each deal
TRANSACTION_NO	NUMBER		Refer to QRM_CURRENT_DEALS_V.
MARKET_DATA_SET	VARCHAR2	(30)	Refer to QRM_CURRENT_DEALS_V.
CALL_OR_PUT	VARCHAR2	(5)	Refer to QRM_CURRENT_DEALS_V.
OPTION_STYLE	VARCHAR2	(8)	Refer to QRM_CURRENT_DEALS_V.
ISSUER_CODE	VARCHAR2	(7)	Refer to QRM_CURRENT_DEALS_V.
COMPANY_CODE	VARCHAR2	(7)	Refer to QRM_CURRENT_DEALS_V.
DEALER_CODE	VARCHAR2	(10)	Refer to QRM_CURRENT_DEALS_V.
CLIENT_CODE	VARCHAR2	(7)	Refer to QRM_CURRENT_DEALS_V.
CPARTY_CODE	VARCHAR2	(7)	Refer to QRM_CURRENT_DEALS_V.
PORTFOLIO_CODE	VARCHAR2	(7)	Refer to QRM_CURRENT_DEALS_V.
LINK_CODE	VARCHAR2	(8)	Refer to QRM_CURRENT_DEALS_V.
PRICING_MODEL	VARCHAR2	(13)	Refer to QRM_CURRENT_DEALS_V.
DEAL_CCY	VARCHAR2	(15)	Refer to QRM_CURRENT_DEALS_V.
BUY_CCY	VARCHAR2	(15)	Refer to QRM_CURRENT_DEALS_V.
SELL_CCY	VARCHAR2	(15)	Refer to QRM_CURRENT_DEALS_V.
FOREIGN_CCY	VARCHAR2	(15)	Refer to QRM_CURRENT_DEALS_V.
DOMESTIC_CCY	VARCHAR2	(15)	Refer to QRM_CURRENT_DEALS_V.
BASE_CCY	VARCHAR2	(15)	Refer to QRM_CURRENT_DEALS_V.
CONTRA_CCY	VARCHAR2	(15)	Refer to QRM_CURRENT_DEALS_V.
SENSITIVITY_CCY	VARCHAR2	(15)	Refer to QRM_CURRENT_DEALS_V.
PREMIUM_CCY	VARCHAR2	(15)	Refer to QRM_CURRENT_DEALS_V.
BUY_AMOUNT	NUMBER		Refer to QRM_CURRENT_DEALS_V.
SELL_AMOUNT	NUMBER		Refer to QRM_CURRENT_DEALS_V.
FOREIGN_AMOUNT	NUMBER		Refer to QRM_CURRENT_DEALS_V.
DOMESTIC_AMOUNT	NUMBER		Refer to QRM_CURRENT_DEALS_V.
BASE_CCY_AMOUNT	NUMBER		Refer to QRM_CURRENT_DEALS_V.
CONTRA_CCY_AMOUNT	NUMBER		Refer to QRM_CURRENT_DEALS_V.
START_AMOUNT	NUMBER		Refer to QRM_CURRENT_DEALS_V.
FACE_VALUE	NUMBER		Refer to QRM_CURRENT_DEALS_V.
INTEREST	NUMBER		Refer to QRM_CURRENT_DEALS_V.
ACCUM_INTEREST_BF	NUMBER		Refer to QRM_CURRENT_DEALS_V.
ACCUM_INT_ACTION	VARCHAR2	(7)	Refer to QRM_CURRENT_DEALS_V.
ACCRUED_INTEREST	NUMBER		Refer to QRM_CURRENT_DEALS_V.
INTEREST_SETTLED	NUMBER		Refer to QRM_CURRENT_DEALS_V.
DEAL_DATE	DATE		Refer to QRM_CURRENT_DEALS_V.
END_DATE	DATE		Refer to QRM_CURRENT_DEALS_V.
GAP_DATE	DATE		Refer to QRM_CURRENT_DEALS_V.
DEAL_SUBTYPE	VARCHAR2	(7)	Refer to QRM_CURRENT_DEALS_V.
DEAL_TYPE	VARCHAR2	(7)	Refer to QRM_CURRENT_DEALS_V.
DISCOUNT_YIELD	VARCHAR2	(1)	Refer to QRM_CURRENT_DEALS_V.
EXPIRATION_DATE	DATE		Refer to QRM_CURRENT_DEALS_V.
MATURITY_DATE	DATE		Refer to QRM_CURRENT_DEALS_V.
NO_OF_DAYS	NUMBER		Refer to QRM_CURRENT_DEALS_V.
VALUE_DATE	DATE		Refer to QRM_CURRENT_DEALS_V.
SETTLE_DATE	DATE		Refer to QRM_CURRENT_DEALS_V.
PREMIUM_AMOUNT	NUMBER		Refer to QRM_CURRENT_DEALS_V.
PRODUCT_TYPE	VARCHAR2	(10)	Refer to QRM_CURRENT_DEALS_V.
START_DATE	DATE		Refer to QRM_CURRENT_DEALS_V.
PHY_START_DATE	DATE		Refer to QRM_CURRENT_DEALS_V.
KNOCK_TYPE	VARCHAR2	(10)	Refer to QRM_CURRENT_DEALS_V.
KNOCK_LEVEL	NUMBER		Refer to QRM_CURRENT_DEALS_V.
KNOCK_EXECUTE_DATE	DATE		Refer to QRM_CURRENT_DEALS_V.
INITIAL_BASIS	VARCHAR2	(5)	Refer to QRM_CURRENT_DEALS_V.
INT_SWAP_REF	VARCHAR2	(10)	Refer to QRM_CURRENT_DEALS_V.
INT_REF	VARCHAR2	(20)	Refer to QRM_CURRENT_DEALS_V.
BOND_ISSUE_CODE	VARCHAR2	(30)	Refer to QRM_CURRENT_DEALS_V.
SECURITY_ID	VARCHAR2	(15)	Refer to QRM_CURRENT_DEALS_V.
REF_SPOT_RATE	NUMBER		Refer to QRM_CURRENT_DEALS_V.
COUPON_ACTION	VARCHAR2	(3)	Refer to QRM_CURRENT_DEALS_V.
COUPON_RATE	NUMBER		Refer to QRM_CURRENT_DEALS_V.
MARGIN	NUMBER		Refer to QRM_CURRENT_DEALS_V.
TRANSACTION_RATE	NUMBER		Refer to QRM_CURRENT_DEALS_V.
INTEREST_FREQUENCY	VARCHAR2	(1)	Refer to QRM_CURRENT_DEALS_V.
COUPON_FREQUENCY	NUMBER		Refer to QRM_CURRENT_DEALS_V.
NEXT_COUPON_DATE	DATE		Refer to QRM_CURRENT_DEALS_V.
DAY_COUNT_BASIS	VARCHAR2	(15)	Refer to QRM_CURRENT_DEALS_V.
QUANTITY_REMAINING	NUMBER		Refer to QRM_CURRENT_DEALS_V.
QUANTITY_REMAINING_USD	NUMBER		Refer to QRM_CURRENT_DEALS_V.
QUANTITY_REMAINING_SOB	NUMBER		Refer to QRM_CURRENT_DEALS_V.
ROUNDING_TYPE	VARCHAR2	(1)	Code for interest rounding
DAY_COUNT_TYPE	VARCHAR2	(1)	Code for interest includes
PREPAID_INTEREST	VARCHAR2	(1)	Flag to indicate if the deal's interest was prepaid.
STATUS_CODE	VARCHAR2	(10)	Refer to QRM_CURRENT_DEALS_V.
DEAL_TYPE_DESC	VARCHAR2	(80)	Refer to QRM_CURRENT_DEALS_V.
DEAL_SUBTYPE_DESC	VARCHAR2	(80)	Refer to QRM_CURRENT_DEALS_V.
PRODUCT_TYPE_DESC	VARCHAR2	(80)	Refer to QRM_CURRENT_DEALS_V.
COMPANY_FULL_NAME	VARCHAR2	(50)	Refer to QRM_CURRENT_DEALS_V.
CPARTY_FULL_NAME	VARCHAR2	(50)	Refer to QRM_CURRENT_DEALS_V.

Query Text

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


SELECT DEAL_NO
,      TRANSACTION_NO
,      MARKET_DATA_SET
,      CALL_OR_PUT
,      OPTION_STYLE
,      ISSUER_CODE
,      COMPANY_CODE
,      DEALER_CODE
,      CLIENT_CODE
,      CPARTY_CODE
,      PORTFOLIO_CODE
,      LINK_CODE
,      PRICING_MODEL
,      DEAL_CCY
,      BUY_CCY
,      SELL_CCY
,      FOREIGN_CCY
,      DOMESTIC_CCY
,      BASE_CCY
,      CONTRA_CCY
,      SENSITIVITY_CCY
,      PREMIUM_CCY
,      BUY_AMOUNT
,      SELL_AMOUNT
,      FOREIGN_AMOUNT
,      DOMESTIC_AMOUNT
,      BASE_CCY_AMOUNT
,      CONTRA_CCY_AMOUNT
,      START_AMOUNT
,      FACE_VALUE
,      INTEREST
,      ACCUM_INTEREST_BF
,      ACCUM_INT_ACTION
,      ACCRUED_INTEREST
,      INTEREST_SETTLED
,      DEAL_DATE
,      END_DATE
,      GAP_DATE
,      DEAL_SUBTYPE
,      DEAL_TYPE
,      DISCOUNT_YIELD
,      EXPIRATION_DATE
,      MATURITY_DATE
,      NO_OF_DAYS
,      VALUE_DATE
,      SETTLE_DATE
,      PREMIUM_AMOUNT
,      PRODUCT_TYPE
,      START_DATE
,      PHY_START_DATE
,      KNOCK_TYPE
,      KNOCK_LEVEL
,      KNOCK_EXECUTE_DATE
,      INITIAL_BASIS
,      INT_SWAP_REF
,      INT_REF
,      BOND_ISSUE_CODE
,      SECURITY_ID
,      REF_SPOT_RATE
,      COUPON_ACTION
,      COUPON_RATE
,      MARGIN
,      TRANSACTION_RATE
,      INTEREST_FREQUENCY
,      COUPON_FREQUENCY
,      NEXT_COUPON_DATE
,      DAY_COUNT_BASIS
,      QUANTITY_REMAINING
,      QUANTITY_REMAINING_USD
,      QUANTITY_REMAINING_SOB
,      ROUNDING_TYPE
,      DAY_COUNT_TYPE
,      PREPAID_INTEREST
,      STATUS_CODE
,      DEAL_TYPE_DESC
,      DEAL_SUBTYPE_DESC
,      PRODUCT_TYPE_DESC
,      COMPANY_FULL_NAME
,      CPARTY_FULL_NAME
FROM APPS.XTR_DISC_DEALS_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.XTR_DISC_DEALS_TRANSACTIONS_V references the following:

APPS: FND_GLOBAL - show dependent code; XTR_BOND_ISSUES; XTR_BUY_SELL_COMBINATIONS; XTR_COMPANY_AUTHORITIES; XTR_DEALER_CODES; XTR_DEALS; XTR_DEAL_SUBTYPES; XTR_DEAL_TYPES; XTR_EXPOSURE_TRANSACTIONS; XTR_INTERGROUP_TRANSFERS; XTR_PARTY_INFO; XTR_PRODUCT_TYPES; XTR_ROLLOVER_TRANSACTIONS

APPS.XTR_DISC_DEALS_TRANSACTIONS_V is not referenced by any database object