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

VIEW: APPS.QRM_ANALYSIS_DISC_V

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

View Type

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


The QRM_ANALYSIS_DISC_V view contains the same information provided by the
QRM_ANALYSIS_DEALS_V view, and, in addition, shows those attributes where the
values may change over time, such as an outstanding amount or interest basis.
When multiple values associated with different points in time, this view shows
only the value associated with the earliest date stored in the
QRM_TB_CALCULATIONS table.


[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
INTEREST_BASIS VARCHAR2 (1)
Refer to base table or view
OUTSTANDING_AMOUNT NUMBER

Refer to base table or view
COUPON_RATE NUMBER

Refer to base table or view
NEXT_COUPON_DATE DATE

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
,      INTEREST_BASIS
,      OUTSTANDING_AMOUNT
,      COUPON_RATE
,      NEXT_COUPON_DATE
FROM APPS.QRM_ANALYSIS_DISC_V;

Dependencies

[top of page]

APPS.QRM_ANALYSIS_DISC_V references the following:

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

APPS.QRM_ANALYSIS_DISC_V is not referenced by any database object