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: QRM.QRM_DEAL_CALCULATIONS#

Object Details

Object Name:	QRM_DEAL_CALCULATIONS#
Object Type:	VIEW
Owner:	QRM
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
DEAL_CALC_ID	NUMBER		Yes
DEAL_NO	NUMBER		Yes
TRANSACTION_NO	NUMBER		Yes
MARKET_DATA_SET	VARCHAR2	(20)	Yes
DEAL_CCY	VARCHAR2	(15)
SOB_CCY	VARCHAR2	(15)
BASE_CCY_AMOUNT_USD	NUMBER
BASE_CCY_AMOUNT_SOB	NUMBER
CONTRA_CCY_AMOUNT_USD	NUMBER
CONTRA_CCY_AMOUNT_SOB	NUMBER
FOREIGN_AMOUNT_USD	NUMBER
FOREIGN_AMOUNT_SOB	NUMBER
DOMESTIC_AMOUNT_USD	NUMBER
DOMESTIC_AMOUNT_SOB	NUMBER
BUY_AMOUNT_USD	NUMBER
BUY_AMOUNT_SOB	NUMBER
SELL_AMOUNT_USD	NUMBER
SELL_AMOUNT_SOB	NUMBER
DAYS	NUMBER		Yes
FX_REVAL_RATE	NUMBER
MM_REVAL_RATE	NUMBER
FX_TRANS_RATE	NUMBER
MM_TRANS_RATE	NUMBER
FAIR_VALUE	NUMBER
FAIR_VALUE_USD	NUMBER
FAIR_VALUE_SOB	NUMBER
GAP_AMOUNT	NUMBER
GAP_AMOUNT_USD	NUMBER
GAP_AMOUNT_SOB	NUMBER
MATURITY_AMOUNT	NUMBER
MATURITY_AMOUNT_USD	NUMBER
MATURITY_AMOUNT_SOB	NUMBER
PREMIUM_AMOUNT_USD	NUMBER
PREMIUM_AMOUNT_SOB	NUMBER
ACCRUED_INTEREST	NUMBER
ACCRUED_INTEREST_USD	NUMBER
ACCRUED_INTEREST_SOB	NUMBER
DURATION	NUMBER
MODIFIED_DURATION	NUMBER
CONVEXITY	NUMBER
DELTA	NUMBER
GAMMA	NUMBER
THETA	NUMBER
RHO_FOREIGN	NUMBER
RHO_DOMESTIC	NUMBER
VEGA	NUMBER
POS_BPV	NUMBER
POS_DELTA	NUMBER
POS_GAMMA	NUMBER
POS_RHO_FOREIGN	NUMBER
POS_RHO_DOMESTIC	NUMBER
POS_VEGA	NUMBER
VOLATILITY	NUMBER
GAP_DATE	DATE
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
RHO	NUMBER
RHO_BASE	NUMBER
RHO_CONTRA	NUMBER
POS_RHO	NUMBER
POS_RHO_USD	NUMBER
POS_RHO_SOB	NUMBER
POS_RHO_BASE	NUMBER
POS_RHO_BASE_USD	NUMBER
POS_RHO_BASE_SOB	NUMBER
POS_RHO_CONTRA	NUMBER
POS_RHO_CONTRA_USD	NUMBER
POS_RHO_CONTRA_SOB	NUMBER
POS_RHO_FOREIGN_USD	NUMBER
POS_RHO_FOREIGN_SOB	NUMBER
POS_RHO_DOMESTIC_USD	NUMBER
POS_RHO_DOMESTIC_SOB	NUMBER
POS_BPV_USD	NUMBER
POS_BPV_SOB	NUMBER
POS_DELTA_USD	NUMBER
POS_DELTA_SOB	NUMBER
POS_GAMMA_USD	NUMBER
POS_GAMMA_SOB	NUMBER
POS_THETA	NUMBER
POS_THETA_USD	NUMBER
POS_THETA_SOB	NUMBER
POS_VEGA_USD	NUMBER
POS_VEGA_SOB	NUMBER
YIELD_TO_MATURITY	NUMBER
LAST_MD_CALC_DATE	DATE
TRANSACTION_PRICE	NUMBER
TRANSACTION_PRICE_USD	NUMBER
TRANSACTION_PRICE_SOB	NUMBER
REVALUATION_PRICE	NUMBER
REVALUATION_PRICE_USD	NUMBER
REVALUATION_PRICE_SOB	NUMBER

Query Text

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


SELECT DEAL_CALC_ID
,      DEAL_NO
,      TRANSACTION_NO
,      MARKET_DATA_SET
,      DEAL_CCY
,      SOB_CCY
,      BASE_CCY_AMOUNT_USD
,      BASE_CCY_AMOUNT_SOB
,      CONTRA_CCY_AMOUNT_USD
,      CONTRA_CCY_AMOUNT_SOB
,      FOREIGN_AMOUNT_USD
,      FOREIGN_AMOUNT_SOB
,      DOMESTIC_AMOUNT_USD
,      DOMESTIC_AMOUNT_SOB
,      BUY_AMOUNT_USD
,      BUY_AMOUNT_SOB
,      SELL_AMOUNT_USD
,      SELL_AMOUNT_SOB
,      DAYS
,      FX_REVAL_RATE
,      MM_REVAL_RATE
,      FX_TRANS_RATE
,      MM_TRANS_RATE
,      FAIR_VALUE
,      FAIR_VALUE_USD
,      FAIR_VALUE_SOB
,      GAP_AMOUNT
,      GAP_AMOUNT_USD
,      GAP_AMOUNT_SOB
,      MATURITY_AMOUNT
,      MATURITY_AMOUNT_USD
,      MATURITY_AMOUNT_SOB
,      PREMIUM_AMOUNT_USD
,      PREMIUM_AMOUNT_SOB
,      ACCRUED_INTEREST
,      ACCRUED_INTEREST_USD
,      ACCRUED_INTEREST_SOB
,      DURATION
,      MODIFIED_DURATION
,      CONVEXITY
,      DELTA
,      GAMMA
,      THETA
,      RHO_FOREIGN
,      RHO_DOMESTIC
,      VEGA
,      POS_BPV
,      POS_DELTA
,      POS_GAMMA
,      POS_RHO_FOREIGN
,      POS_RHO_DOMESTIC
,      POS_VEGA
,      VOLATILITY
,      GAP_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RHO
,      RHO_BASE
,      RHO_CONTRA
,      POS_RHO
,      POS_RHO_USD
,      POS_RHO_SOB
,      POS_RHO_BASE
,      POS_RHO_BASE_USD
,      POS_RHO_BASE_SOB
,      POS_RHO_CONTRA
,      POS_RHO_CONTRA_USD
,      POS_RHO_CONTRA_SOB
,      POS_RHO_FOREIGN_USD
,      POS_RHO_FOREIGN_SOB
,      POS_RHO_DOMESTIC_USD
,      POS_RHO_DOMESTIC_SOB
,      POS_BPV_USD
,      POS_BPV_SOB
,      POS_DELTA_USD
,      POS_DELTA_SOB
,      POS_GAMMA_USD
,      POS_GAMMA_SOB
,      POS_THETA
,      POS_THETA_USD
,      POS_THETA_SOB
,      POS_VEGA_USD
,      POS_VEGA_SOB
,      YIELD_TO_MATURITY
,      LAST_MD_CALC_DATE
,      TRANSACTION_PRICE
,      TRANSACTION_PRICE_USD
,      TRANSACTION_PRICE_SOB
,      REVALUATION_PRICE
,      REVALUATION_PRICE_USD
,      REVALUATION_PRICE_SOB
FROM QRM.QRM_DEAL_CALCULATIONS#;

Dependencies

[top of page]

QRM.QRM_DEAL_CALCULATIONS# references the following:

QRM: QRM_DEAL_CALCULATIONS

QRM.QRM_DEAL_CALCULATIONS# is referenced by following:

APPS: QRM_DEAL_CALCULATIONS