[Home] [Help] [Dependency Information]
Object Name: | QRM_DEAL_CALCULATIONS# |
---|---|
Object Type: | VIEW |
Owner: | QRM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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#;
|
|
|