DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.QRM_ANALYSIS_DEALS_V

Object Details
Object Name: QRM_ANALYSIS_DEALS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewQRM.QRM_ANALYSIS_DEALS_V
Subobject Name:
Status: VALID

View Type

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


The QRM_ANALYSIS_DEALS_V view contains all of the calculated and
non-calculated attributes for the deal. This view is mainly derived from a
join between the QRM_CURRENT_DEALS_V view and the QRM_DEAL_CALCULATIONS table.
This view will only show Treasury deals that the user has access to, with
CURRENT status, and that are included in analyses that was run.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CALL_OR_PUT VARCHAR2 (5)
Refer to base table or view
OPTION_STYLE VARCHAR2 (8)
Refer to base table or view
COMPANY_CODE VARCHAR2 (7)
Refer to base table or view
DEALER_CODE VARCHAR2 (10)
Refer to base table or view
CLIENT_CODE VARCHAR2 (7)
Refer to base table or view
CPARTY_CODE VARCHAR2 (7)
Refer to base table or view
PORTFOLIO_CODE VARCHAR2 (7)
Refer to base table or view
LINK_CODE VARCHAR2 (8)
Refer to base table or view
PRICING_MODEL VARCHAR2 (13)
Refer to base table or view
BUY_CCY VARCHAR2 (15)
Refer to base table or view
SELL_CCY VARCHAR2 (15)
Refer to base table or view
FOREIGN_CCY VARCHAR2 (15)
Refer to base table or view
DOMESTIC_CCY VARCHAR2 (15)
Refer to base table or view
BASE_CCY VARCHAR2 (15)
Refer to base table or view
CONTRA_CCY VARCHAR2 (15)
Refer to base table or view
BUY_AMOUNT NUMBER

Refer to base table or view
SELL_AMOUNT NUMBER

Refer to base table or view
FOREIGN_AMOUNT NUMBER

Refer to base table or view
DOMESTIC_AMOUNT NUMBER

Refer to base table or view
BASE_CCY_AMOUNT NUMBER

Refer to base table or view
CONTRA_CCY_AMOUNT NUMBER

Refer to base table or view
DEAL_DATE DATE

Refer to base table or view
END_DATE DATE

Refer to base table or view
DEAL_SUBTYPE VARCHAR2 (7) Yes Refer to base table or view
DEAL_TYPE VARCHAR2 (7) Yes Refer to base table or view
EXPIRATION_DATE DATE

Refer to base table or view
MATURITY_DATE DATE

Refer to base table or view
MARKET_TYPE VARCHAR2 (1)
Refer to base table or view
INSTR_TYPE VARCHAR2 (1)
Refer to base table or view
MM_FX_INSTR_TYPE VARCHAR2 (1)
Refer to base table or view
VALUE_DATE DATE

Refer to base table or view
PREMIUM_AMOUNT NUMBER

Refer to base table or view
PRODUCT_TYPE VARCHAR2 (10)
Refer to base table or view
START_DATE DATE

Refer to base table or view
KNOCK_EXECUTE_DATE DATE

Refer to base table or view
KNOCK_TYPE VARCHAR2 (10)
Refer to base table or view
KNOCK_LEVEL NUMBER

Refer to base table or view
INT_SWAP_REF VARCHAR2 (10)
Refer to base table or view
INT_REF VARCHAR2 (20)
Refer to base table or view
BOND_ISSUE_CODE VARCHAR2 (30)
Refer to base table or view
SECURITY_ID VARCHAR2 (15)
Refer to base table or view
REF_SPOT_RATE NUMBER

Refer to base table or view
MARGIN NUMBER

Refer to base table or view
COUPON_FREQUENCY NUMBER

Refer to base table or view
DAY_COUNT_BASIS VARCHAR2 (15)
Refer to base table or view
DEAL_NO NUMBER
Yes Refer to base table or view
TRANSACTION_NO VARCHAR2 (40)
Refer to base table or view
MARKET_DATA_SET VARCHAR2 (20) Yes Refer to base table or view
DEAL_CCY VARCHAR2 (15)
Refer to base table or view
SOB_CCY VARCHAR2 (15)
Refer to base table or view
BASE_CCY_AMOUNT_USD NUMBER

Refer to base table or view
BASE_CCY_AMOUNT_SOB NUMBER

Refer to base table or view
CONTRA_CCY_AMOUNT_USD NUMBER

Refer to base table or view
CONTRA_CCY_AMOUNT_SOB NUMBER

Refer to base table or view
FOREIGN_AMOUNT_USD NUMBER

Refer to base table or view
FOREIGN_AMOUNT_SOB NUMBER

Refer to base table or view
DOMESTIC_AMOUNT_USD NUMBER

Refer to base table or view
DOMESTIC_AMOUNT_SOB NUMBER

Refer to base table or view
BUY_AMOUNT_USD NUMBER

Refer to base table or view
BUY_AMOUNT_SOB NUMBER

Refer to base table or view
SELL_AMOUNT_USD NUMBER

Refer to base table or view
SELL_AMOUNT_SOB NUMBER

Refer to base table or view
DAYS NUMBER
Yes Refer to base table or view
FX_REVAL_RATE NUMBER

Refer to base table or view
MM_REVAL_RATE NUMBER

Refer to base table or view
FX_TRANS_RATE NUMBER

Refer to base table or view
MM_TRANS_RATE NUMBER

Refer to base table or view
FAIR_VALUE NUMBER

Refer to base table or view
FAIR_VALUE_USD NUMBER

Refer to base table or view
FAIR_VALUE_SOB NUMBER

Refer to base table or view
GAP_AMOUNT NUMBER

Refer to base table or view
GAP_AMOUNT_USD NUMBER

Refer to base table or view
GAP_AMOUNT_SOB NUMBER

Refer to base table or view
MATURITY_AMOUNT NUMBER

Refer to base table or view
MATURITY_AMOUNT_USD NUMBER

Refer to base table or view
MATURITY_AMOUNT_SOB NUMBER

Refer to base table or view
PREMIUM_AMOUNT_USD NUMBER

Refer to base table or view
PREMIUM_AMOUNT_SOB NUMBER

Refer to base table or view
ACCRUED_INTEREST NUMBER

Refer to base table or view
ACCRUED_INTEREST_USD NUMBER

Refer to base table or view
ACCRUED_INTEREST_SOB NUMBER

Refer to base table or view
DURATION NUMBER

Refer to base table or view
MODIFIED_DURATION NUMBER

Refer to base table or view
CONVEXITY NUMBER

Refer to base table or view
DELTA NUMBER

Refer to base table or view
GAMMA NUMBER

Refer to base table or view
THETA NUMBER

Refer to base table or view
RHO_FOREIGN NUMBER

Refer to base table or view
RHO_DOMESTIC NUMBER

Refer to base table or view
VEGA NUMBER

Refer to base table or view
POS_BPV NUMBER

Refer to base table or view
POS_DELTA NUMBER

Refer to base table or view
POS_GAMMA NUMBER

Refer to base table or view
POS_RHO_FOREIGN NUMBER

Refer to base table or view
POS_RHO_DOMESTIC NUMBER

Refer to base table or view
POS_VEGA NUMBER

Refer to base table or view
VOLATILITY NUMBER

Refer to base table or view
GAP_DATE DATE

Refer to base table or view
RHO NUMBER

Refer to base table or view
RHO_BASE NUMBER

Refer to base table or view
RHO_CONTRA NUMBER

Refer to base table or view
POS_RHO NUMBER

Refer to base table or view
POS_RHO_USD NUMBER

Refer to base table or view
POS_RHO_SOB NUMBER

Refer to base table or view
POS_RHO_BASE NUMBER

Refer to base table or view
POS_RHO_BASE_USD NUMBER

Refer to base table or view
POS_RHO_BASE_SOB NUMBER

Refer to base table or view
POS_RHO_CONTRA NUMBER

Refer to base table or view
POS_RHO_CONTRA_USD NUMBER

Refer to base table or view
POS_RHO_CONTRA_SOB NUMBER

Refer to base table or view
POS_RHO_FOREIGN_USD NUMBER

Refer to base table or view
POS_RHO_FOREIGN_SOB NUMBER

Refer to base table or view
POS_RHO_DOMESTIC_USD NUMBER

Refer to base table or view
POS_RHO_DOMESTIC_SOB NUMBER

Refer to base table or view
POS_BPV_USD NUMBER

Refer to base table or view
POS_BPV_SOB NUMBER

Refer to base table or view
POS_DELTA_USD NUMBER

Refer to base table or view
POS_DELTA_SOB NUMBER

Refer to base table or view
POS_GAMMA_USD NUMBER

Refer to base table or view
POS_GAMMA_SOB NUMBER

Refer to base table or view
POS_VEGA_USD NUMBER

Refer to base table or view
POS_VEGA_SOB NUMBER

Refer to base table or view
POS_THETA NUMBER

Refer to base table or view
POS_THETA_USD NUMBER

Refer to base table or view
POS_THETA_SOB NUMBER

Refer to base table or view
YIELD_TO_MATURITY NUMBER

Refer to base table or view
Query Text

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


SELECT CALL_OR_PUT
,      OPTION_STYLE
,      COMPANY_CODE
,      DEALER_CODE
,      CLIENT_CODE
,      CPARTY_CODE
,      PORTFOLIO_CODE
,      LINK_CODE
,      PRICING_MODEL
,      BUY_CCY
,      SELL_CCY
,      FOREIGN_CCY
,      DOMESTIC_CCY
,      BASE_CCY
,      CONTRA_CCY
,      BUY_AMOUNT
,      SELL_AMOUNT
,      FOREIGN_AMOUNT
,      DOMESTIC_AMOUNT
,      BASE_CCY_AMOUNT
,      CONTRA_CCY_AMOUNT
,      DEAL_DATE
,      END_DATE
,      DEAL_SUBTYPE
,      DEAL_TYPE
,      EXPIRATION_DATE
,      MATURITY_DATE
,      MARKET_TYPE
,      INSTR_TYPE
,      MM_FX_INSTR_TYPE
,      VALUE_DATE
,      PREMIUM_AMOUNT
,      PRODUCT_TYPE
,      START_DATE
,      KNOCK_EXECUTE_DATE
,      KNOCK_TYPE
,      KNOCK_LEVEL
,      INT_SWAP_REF
,      INT_REF
,      BOND_ISSUE_CODE
,      SECURITY_ID
,      REF_SPOT_RATE
,      MARGIN
,      COUPON_FREQUENCY
,      DAY_COUNT_BASIS
,      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
,      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_VEGA_USD
,      POS_VEGA_SOB
,      POS_THETA
,      POS_THETA_USD
,      POS_THETA_SOB
,      YIELD_TO_MATURITY
FROM APPS.QRM_ANALYSIS_DEALS_V;

Dependencies

[top of page]

APPS.QRM_ANALYSIS_DEALS_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewQRM_CURRENT_DEALS_V
SynonymQRM_DEAL_CALCULATIONS
SynonymXTR_DEAL_SUBTYPES
SynonymXTR_DEAL_TYPES

APPS.QRM_ANALYSIS_DEALS_V is not referenced by any database object