Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - QRM Tables and Views

TABLE - QRM.QRM_ANALYSIS_ATTS
TABLE - QRM.QRM_ANALYSIS_SETTINGS
TABLE - QRM.QRM_ANA_ATTS_LOOKUPS
TABLE - QRM.QRM_DEALS_ANALYSES
TABLE - QRM.QRM_DEAL_CALCULATIONS
TABLE - QRM.QRM_DEAL_CALC_ERRORS
TABLE - QRM.QRM_FILTERS
TABLE - QRM.QRM_FILTER_CONDITIONS
TABLE - QRM.QRM_SAVED_ANALYSES_COL
TABLE - QRM.QRM_SAVED_ANALYSES_ROW
TABLE - QRM.QRM_TB_CALCULATIONS
TABLE - QRM.QRM_TIME_BUCKETS
TABLE - QRM.QRM_TIME_INTERVALS
VIEW - APPS.QRM_ANALYSIS_DEALS_V
VIEW - APPS.QRM_ANALYSIS_DISC_V
VIEW - APPS.QRM_CURRENT_DEALS_V
VIEW - APPS.QRM_DISC_ANALYSIS_TB_V
VIEW - APPS.QRM_DISC_ANALYSIS_V

Table: QRM_ANALYSIS_ATTS

Description: Analysis Attributes Information
Primary Key: QRM_ANALYSIS_ATTS_PK
  1. ATTRIBUTE_NAME
  2. ANALYSIS_NAME
  3. HISTORY_FLAG
Foreign Keys from this table:
Foreign Key Column Foreign Table
QRM_ANALYSIS_ATTS.ATTRIBUTE_NAME QRM_ANA_ATTS_LOOKUPS
QRM_ANALYSIS_ATTS.ANALYSIS_NAME
QRM_ANALYSIS_ATTS.HISTORY_FLAG 		QRM_ANALYSIS_SETTINGS
Comments

QRM_ANALYSIS_ATTS contains the setup data for analyses. Each row corresponds to a deal attribute. This table contains both saved and current attributes for analyses. Risk analysis displays results based on the saved analysis but bases its calculations on the current one. Each row has a corresponding row in QRM_ANALYSIS_SETTINGS indexed by the ANALYSIS_NAME, which represents the settings for the analysis.

Indexes
Index Type Tablespace Column
QRM_ANALYSIS_ATTS_U1 UNIQUE APPS_TS_TX_IDX ATTRIBUTE_NAME
ANALYSIS_NAME
HISTORY_FLAG
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_NAME VARCHAR2 (20) Y Name of the deal attribute
ANALYSIS_NAME VARCHAR2 (20) Y Name of parent analysis.
HISTORY_FLAG VARCHAR2 (1) Y Indicates if analysis attribute is current (C) or saved (S).
TYPE VARCHAR2 (1) Y Type of attribute: Measure 'M', List 'L', Aggregate 'A', Column, 'C', Row 'R'
ATT_ORDER NUMBER

The order in which the attribute is displayed or aggregated, depending on what the user selected when the analysis was set up.
TOTAL_AVERAGE VARCHAR2 (1)
Indicates if attribute is averaged or summed: Average 'A', Sum 'T'
TOTAL_IND VARCHAR2 (1)
Indicates if users wishes to see totals on an attribute that can be aggregated.
PERCENTAGE VARCHAR2 (1)
Indicates if the user wishes to see percentage on am attribute that can be aggregated.
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

QRM.QRM_ANALYSIS_ATTS does not reference any database object

QRM.QRM_ANALYSIS_ATTS is referenced by following:

QRM
VIEW - QRM_ANALYSIS_ATTS#

[top of page]

Table: QRM_ANALYSIS_SETTINGS

Description: Analysis Settings Information
Primary Key: QRM_ANALYSIS_SETTINGS_PK
  1. ANALYSIS_NAME
  2. HISTORY_FLAG
Foreign Keys from this table:
Foreign Key Column Foreign Table
QRM_ANALYSIS_SETTINGS.FILTER_NAME QRM_FILTERS
QRM_ANALYSIS_SETTINGS.TB_NAME QRM_TIME_BUCKETS
QRM_ANALYSIS_SETTINGS.MD_SET_CODE XTR_RM_MD_SETS
QRM_ANALYSIS_SETTINGS.GL_CALENDAR_ID GL_TRANSACTION_CALENDAR
QRM_ANALYSIS_SETTINGS.PROCESS_ID FND_CONCURRENT_REQUESTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
QRM_ANALYSIS_ATTS.ANALYSIS_NAME
QRM_ANALYSIS_ATTS.HISTORY_FLAG 		QRM_ANALYSIS_SETTINGS
Comments

QRM_ANALYSIS_SETTINGS contains the setup data for analyses. Each row corresponds to a single analysis and its state, which is either "current" or "saved." Risk analysis displays results based on the saved rows but bases its calculations on the current rows. This table stores all analysis settings information except those that are tied to deal attributes. Such analysis attributes information is stored in QRM_ANALYSIS_ATTS.

Indexes
Index Type Tablespace Column
QRM_ANALYSIS_SETTINGS_U1 UNIQUE APPS_TS_TX_IDX ANALYSIS_NAME
HISTORY_FLAG
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
ANALYSIS_NAME VARCHAR2 (20) Y Name of the analysis.
HISTORY_FLAG VARCHAR2 (1) Y Indicates if the state of the analysis settings is current 'C' or saved 'S'.
ANALYSIS_TYPE VARCHAR2 (1) Y Type of analysis: Gap, Maturity, Position.
STYLE VARCHAR2 (1) Y Style of the analysis: Table 'T', Aggregated Table 'A', Crosstab 'C', Crosstab with Time Buckets 'X'
DATE_TYPE VARCHAR2 (1) Y Indicates if date is relative or fixed.
CURRENCY_SOURCE VARCHAR2 (1) Y Indicates where the results' currency comes from: Deal Currency 'D', Set of Books Currency 'B', Reporting Currency 'R'
UNITS NUMBER
Y Number of units displayed in analysis results.
STATUS VARCHAR2 (1) Y Indicates current status of analysis results: Completed Successfully '0', Completed with warnings '1', Error '2', In progress '3', Never run '4', No results '5'
DIRTY VARCHAR2 (1) Y Indicates level of changes to settings since the last analysis was run: Not dirty 'N', Small changes 'S', Currency Changes 'C', Major Changes 'D'
BUSINESS_WEEK VARCHAR2 (1) Y Indicates what type of calendar week is being used when creating the time buckets structure.
DESCRIPTION VARCHAR2 (50)
Description of the analysis.
FILTER_NAME VARCHAR2 (20)
Filter for the analysis. Corresponds to the FILTER_NAME column in QRM_FILTERS.
MD_SET_CODE VARCHAR2 (20)
Code corresponds to the market data set used in analysis. Corresponds to the SET_CODE column in XTR_RM_MD_SETS.
THRESHOLD_NUM NUMBER

Number of units for the recalculation threshold.
THRESHOLD_TYPE VARCHAR2 (20)
Unit type for the recalculation threshold: Days 'D', Hours 'H', Minutes 'M'
TB_LABEL VARCHAR2 (1)
Indicates the type of label displayed when analysis results contain time buckets: Display Date 'D', User specified Label 'L'
TB_NAME VARCHAR2 (20)
Name of the set of time buckets used in a Crosstab with Time Buckets style analysis. Corresponds to TB_NAME column in QRM_TIME_BUCKETS.
START_DATE DATE

Fixed start date.
END_DATE DATE

Fixed end date.
START_DATE_REF VARCHAR2 (20)
Reference point for relative start date: Beginning of week 'BW', Beginning of month 'BM', Beginning of year 'BY', End of week 'EW', End of month 'EM', End of year 'EY', System Date 'S'
END_DATE_REF VARCHAR2 (20)
Reference point for relative end date:Beginning of week 'BW', Beginning of month 'BM', Beginning of year 'BY', End of week 'EW', End of month 'EM', End of year 'EY', System Date 'S'
START_DATE_OFFSET NUMBER

Unit offset for relative start date.
END_DATE_OFFSET NUMBER

Unit offset for relative end date.
START_OFFSET_TYPE VARCHAR2 (20)
Offset type for relative start date: Day(s) 'D', Week(s) 'W', Month(s) 'M', Year(s) 'Y'
END_OFFSET_TYPE VARCHAR2 (20)
Offset type for relative end date:Day(s) 'D', Week(s) 'W', Month(s) 'M', Year(s) 'Y'
SHOW_TOTALS VARCHAR2 (1)
Indicates whether to show totals (Y) or not (N) for Table style analysis.
CURR_REPORTING VARCHAR2 (15)
Reporting currency input by user. Corresponds to XTR_MASTER_CURRENCIES.CURRENCY
CURRENCY_USED VARCHAR2 (1)
Currency used in results. Corresponds to XTR_MASTER_CURRENCIES.CURRENCY
DEC_PLACES NUMBER

Number of decimal places displayed in analysis results.
PROCESS_ID NUMBER

Process ID of most recent time analysis was run. (concurrent ID)
LAST_RUN_DATE DATE

Date of most recent time analysis was run.
GL_CALENDAR_ID NUMBER (15)
ID of calendar selected. Corresponds to L_TRANSACTION_CALENDAR.TRANSACTION_CALENDAR_ID
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

QRM.QRM_ANALYSIS_SETTINGS does not reference any database object

QRM.QRM_ANALYSIS_SETTINGS is referenced by following:

QRM
VIEW - QRM_ANALYSIS_SETTINGS#

[top of page]

Table: QRM_ANA_ATTS_LOOKUPS

Description: Deal attribute properties to control Risk Analysis behavior.
Primary Key: QRM_ANA_ATTS_LOOKUPS_PK
  1. ATTRIBUTE_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
QRM_ANALYSIS_ATTS.ATTRIBUTE_NAME QRM_ANA_ATTS_LOOKUPS
Comments

QRM_ANA_ATTS_LOOKUPS contains the deal attribute properties used to control Risk Analysis behavior. Specifically, these properties control hot to set up analyses and filters and how to calculate analyses results. Each row represents a deal attribute and its properties.

Indexes
Index Type Tablespace Column
QRM_ANA_ATTS_LOOKUPS_U1 UNIQUE APPS_TS_SEED ATTRIBUTE_NAME
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_NAME VARCHAR2 (30) Y Name of the attribute
TOTAL_AVERAGE VARCHAR2 (1) Y Indicates if the following actions can be performed on the attribute: summed (T), averaged (A), or neither (N).
AMOUNT VARCHAR2 (1) Y Indicates what the attribute's formatting type; whether it requires formatting, i.e. as an amount (Y), as an integer (I), as an regular number format (F), or not (N).
DATA_TYPE VARCHAR2 (1) Y Indicates data type of the attribute is a string (V), date (D), or number (N).
ATTRIBUTE_TYPE VARCHAR2 (1) Y Indicates if the attribute is an aggregate attribute (A), a measure (M), or a column attribute that cannot be aggregated (L).
APPLIES_TO_GAP VARCHAR2 (1) Y Indicates if the attribute applies to gap analysis (Y) or not (N).
APPLIES_TO_MAT VARCHAR2 (1) Y Indicates if the attribute applies to maturity analysis (Y) or not (N).
APPLIES_TO_POS VARCHAR2 (1) Y Indicates if the attribute applies to position analysis (Y) or not (N).
ORIGIN VARCHAR2 (1) Y Indicates if the attribute value is selected from QRM_ DEAL_CALCULATIONS table (T), QRM_CURRENT_DEALS_V view, or QRM_TB_CALCULATIONS table (B).
FILTER VARCHAR2 (1) Y Indicates if the attribute can be used as a filter (Y) or not (N).
CCY_AGGREGATE VARCHAR2 (1) Y Indicates if the attribute is a currency (Y) or not (N).
SENSITIVITY VARCHAR2 (1) Y Indicates if the attribute is a sensitivity (Y) or not (N).
MM_FX VARCHAR2 (1) Y Indicates if the attribute applies to instruments of type Money Market (M), Foreign Exchange (F), or both (A).
SHUTTLE VARCHAR2 (1) Y Indicates if the attribute visible to the user (Y) or not (N). When defining an analysis, a user can only select those attributes that are visible.
DENOMINATOR VARCHAR2 (240)
SQL formula for the denominator if attribute requires averaging.
NUMERATOR VARCHAR2 (240)
SQL formula for the numerator if attribute requires averaging.
ORIGIN_SOURCE VARCHAR2 (30) Y The source table or view name where the analysis results is derived. These names correspond directly to the ORIGIN column. The sources are QRM_DEAL_CALCULATIONS, QRM_CURRENT_DEALS_V, and QRM_TB_CALCULATIONS.
ORIGIN_SOURCE_ALIAS VARCHAR2 (5) Y The source table or view alias used to construct dynamic SQL necessary to retrieve the analysis results. These aliases correspond directly to the ORIGIN_SOURCE column. The aliases are DC (or QRM_DEAL_CALCULATION), V (or QRM_CURRENT_DEALS_V), and TB (or QRM_TB_CALCULATIONS).
LABEL_SOURCE VARCHAR2 (30)
The source table or view where translated or user-defined labels are derived. Some examples are FND_LOOKUPS, XTR_DEAL_TYPES, and XTR_DEAL_SUBTYPES.
LABEL_SOURCE_ALIAS VARCHAR2 (5)
The source table or view SQL alias where translated or user-defined labels are derived. These aliases directly correspond to the LABEL_SOURCE column. Some examples are 'dt', 'dst', 'ftot', and 'fib'. Since there are multiple FND_LOOKUP types, multiple aliases are necessary to represent them. Those aliases all start with 'f'. For example, 'ftot' corresponds to FND Lookup Type of QRM_TOTAL_LABEL and 'fib' corresponds to QRM_INTEREST_BASIS.
LOOKUP_TYPE VARCHAR2 (30)
The FND Lookup Type for data that have translatable label.
LABEL_SOURCE_COL VARCHAR2 (30)
The column name where the user-defined labels are stored for data that have user-defined labels. These column names belong to the tables or views defined in the LABEL_SOURCE column.
DEAL_CURRENCY_COL VARCHAR2 (30)
Currency ATTRIBUTE_NAME that is pertinent to the data. For example: BUY_AMOUNT's deal currency column is BUY_CCY. These column names belong to the tables or views defined in the ORIGIN_SOURCE column.
RELATION_SWITCHER_COL VARCHAR2 (30)
Contains the AK Item name for the relation switcher that the filter setup page uses to define different sets of filter relations.
VALUE_SWITCHER_COL VARCHAR2 (30)
Contains AK Item name for the value switcher that the filter setup page uses to define different types of filter values.
NUM_DENOM_ORIGIN VARCHAR2 (1)
Indicates the ORIGIN of the given NUMERATOR/ DENOMINATOR formulas: T (0); T and V (1); T and TB (2); and T, V, and TB (3).
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
APPLIES_TO_EQM VARCHAR2 (1) Y Applies to Equity Market
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

QRM.QRM_ANA_ATTS_LOOKUPS does not reference any database object

QRM.QRM_ANA_ATTS_LOOKUPS is referenced by following:

QRM
VIEW - QRM_ANA_ATTS_LOOKUPS#

[top of page]

Table: QRM_DEALS_ANALYSES

Description: Maps the deal calculations that belong to an analysis.
Primary Key: QRM_DEALS_ANALYSES_PK
  1. ANALYSIS_NAME
  2. DEAL_CALC_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
QRM_DEALS_ANALYSES.DEAL_CALC_ID QRM_DEAL_CALCULATIONS
QRM_DEALS_ANALYSES.COMPANY_CODE XTR_PARTY_INFO
Comments

QRM_DEALS_ANALYSES maps the deal calculations in QRM_DEAL_CALCULATIONS that belong to an analysis. Each row identifies a calculation within an analysis.

Indexes
Index Type Tablespace Column
QRM_DEALS_ANALYSES_U1 UNIQUE APPS_TS_TX_IDX DEAL_CALC_ID
ANALYSIS_NAME
Columns
Name Datatype Length Mandatory Comments
DEAL_CALC_ID NUMBER
Y Unique key identifying the calculations
ANALYSIS_NAME VARCHAR2 (20) Y Name of the analysis
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
REQUEST_ID NUMBER (15)
Concurrent request ID
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent program application ID
PROGRAM_ID NUMBER (15)
Concurrent program ID
PROGRAM_UPDATE_DATE DATE

Concurrent program update date
COMPANY_CODE VARCHAR2 (7) Y Company code

[top of page]

QRM.QRM_DEALS_ANALYSES does not reference any database object

QRM.QRM_DEALS_ANALYSES is referenced by following:

QRM
VIEW - QRM_DEALS_ANALYSES#

[top of page]

Table: QRM_DEAL_CALCULATIONS

Description: Calculated deal attributes that do not change over time.
Primary Key: QRM_DEAL_CALCULATIONS_PK
  1. DEAL_CALC_ID
Primary Key: QRM_DEAL_CALCULATIONS_UK1
  1. DEAL_NO
  2. MARKET_DATA_SET
  3. TRANSACTION_NO
Foreign Keys to this table:
Foreign Key Column Foreign Table
QRM_DEALS_ANALYSES.DEAL_CALC_ID QRM_DEAL_CALCULATIONS
QRM_DEAL_CALC_ERRORS.TRANSACTION_NO
QRM_DEAL_CALC_ERRORS.DEAL_NO
QRM_DEAL_CALC_ERRORS.MARKET_DATA_SET 		QRM_DEAL_CALCULATIONS
QRM_TB_CALCULATIONS.TRANSACTION_NO
QRM_TB_CALCULATIONS.DEAL_NO
QRM_TB_CALCULATIONS.MARKET_DATA_SET 		QRM_DEAL_CALCULATIONS
Comments

QRM_DEAL_CALCULATIONS contains calculated attributes for current deals that do not change over time. These attributes include fair values, sensitivities, accrued interest, and so on. Each row corresponds to a set of calculated attributes for a particular deal number, transaction number, and market data set combination.

Indexes
Index Type Tablespace Column
QRM_DEAL_CALCULATIONS_U1 UNIQUE APPS_TS_TX_IDX DEAL_CALC_ID
QRM_DEAL_CALCULATIONS_U2 UNIQUE APPS_TS_TX_IDX DEAL_NO
TRANSACTION_NO
MARKET_DATA_SET
Columns
Name Datatype Length Mandatory Comments
DEAL_CALC_ID NUMBER
Y ID to identify unique deal number, transaction number, and market data set.
DEAL_NO NUMBER
Y Deal number.
TRANSACTION_NO NUMBER
Y Transaction number.
MARKET_DATA_SET VARCHAR2 (20) Y Market data set used for calculation.
DEAL_CCY VARCHAR2 (15)
Currency of deal. For FX deals, this is set of books currency. For FXO deals, this is premium currency.
SOB_CCY VARCHAR2 (15)
Set of books currency.
BASE_CCY_AMOUNT_USD NUMBER

Base currency amount in USD currency.
BASE_CCY_AMOUNT_SOB NUMBER

Base currency amount in set of books currency.
CONTRA_CCY_AMOUNT_USD NUMBER

Contra currency amount in USD currency.
CONTRA_CCY_AMOUNT_SOB NUMBER

Contra currency amount in set of books currency.
FOREIGN_AMOUNT_USD NUMBER

Foreign currency amount in USD currency.
FOREIGN_AMOUNT_SOB NUMBER

Foreign currency amount in set of books currency.
DOMESTIC_AMOUNT_USD NUMBER

Domestic currency amount in USD currency.
DOMESTIC_AMOUNT_SOB NUMBER

Domestic currency amount in set of books currency.
BUY_AMOUNT_USD NUMBER

Buy currency amount in USD currency.
BUY_AMOUNT_SOB NUMBER

Buy currency amount in SOB currency.
SELL_AMOUNT_USD NUMBER

Sell currency amount in USD currency
SELL_AMOUNT_SOB NUMBER

Sell currency amount in set of books currency.
DAYS NUMBER
Y Number of days from reference date to end date.
FX_REVAL_RATE NUMBER

Revaluation rate for foreign exchange deals.
MM_REVAL_RATE NUMBER

Revaluation rate for money market deals.
FX_TRANS_RATE NUMBER

Transaction rate for foreign exchange deals.
MM_TRANS_RATE NUMBER

Transaction rate for money market deals.
FAIR_VALUE NUMBER

Fair value of the deal.
FAIR_VALUE_USD NUMBER

Fair value in USD currency.
FAIR_VALUE_SOB NUMBER

Fair value in set of books currency.
GAP_AMOUNT NUMBER

Gap amount.
GAP_AMOUNT_USD NUMBER

Gap amount in USD currency.
GAP_AMOUNT_SOB NUMBER

Gap amount in set of books currency.
MATURITY_AMOUNT NUMBER

Maturity amount.
MATURITY_AMOUNT_USD NUMBER

Maturity amount in USD currency.
MATURITY_AMOUNT_SOB NUMBER

Maturity amount in set of books currency.
PREMIUM_AMOUNT_USD NUMBER

Premium currency amount in USD currency.
PREMIUM_AMOUNT_SOB NUMBER

Premium currency amount in set of books currency.
ACCRUED_INTEREST NUMBER

Accrued interest.
ACCRUED_INTEREST_USD NUMBER

Accrued interest in USD currency.
ACCRUED_INTEREST_SOB NUMBER

Accrued interest in set of books currency.
DURATION NUMBER

Duration
MODIFIED_DURATION NUMBER

Modified duration
CONVEXITY NUMBER

Convexity
DELTA NUMBER

Delta
GAMMA NUMBER

Gamma
THETA NUMBER

Theta
RHO_FOREIGN NUMBER

Rho or rho foreign
RHO_DOMESTIC NUMBER

Rho domestic
VEGA NUMBER

Vega
POS_BPV NUMBER

Position bpv
POS_DELTA NUMBER

Position delta
POS_GAMMA NUMBER

Position gamma
POS_RHO_FOREIGN NUMBER

Position rho or position rho foreign
POS_RHO_DOMESTIC NUMBER

Position domestic
POS_VEGA NUMBER

Position vega
VOLATILITY NUMBER

Volatility
GAP_DATE DATE

Gap date
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
REQUEST_ID NUMBER (15)
Concurrent program request id.
PROGRAM_APPLICATION_ID NUMBER (15)
Program application id.
PROGRAM_ID NUMBER (15)
Program id
PROGRAM_UPDATE_DATE DATE

Program id
RHO NUMBER

Rho
RHO_BASE NUMBER

Rho Base
RHO_CONTRA NUMBER

Rho Contra
POS_RHO NUMBER

Position Rho
POS_RHO_USD NUMBER

Position Rho in USD currency
POS_RHO_SOB NUMBER

Position Rho in set of books currency
POS_RHO_BASE NUMBER

Position Rho Base
POS_RHO_BASE_USD NUMBER

Position Rho Base in USD currency
POS_RHO_BASE_SOB NUMBER

Position Rho Base in set of books currency
POS_RHO_CONTRA NUMBER

Position Rho Contra
POS_RHO_CONTRA_USD NUMBER

Position Rho Contra in USD currency
POS_RHO_CONTRA_SOB NUMBER

Position Rho Contra in set of books currency
POS_RHO_FOREIGN_USD NUMBER

Position Rho Foreign in USD currency
POS_RHO_FOREIGN_SOB NUMBER

Position Rho Foreign in set of books currency
POS_RHO_DOMESTIC_USD NUMBER

Position Rho Domestic in USD currency
POS_RHO_DOMESTIC_SOB NUMBER

Position Rho Domestic in set of books currency
POS_BPV_USD NUMBER

Position BPV in USD currency
POS_BPV_SOB NUMBER

Position BPV in set of books currency
POS_DELTA_USD NUMBER

Position Delta in USD currency
POS_DELTA_SOB NUMBER

Position Delta in set of books currency
POS_GAMMA_USD NUMBER

Position Gamma in USD currency
POS_GAMMA_SOB NUMBER

Position Gamma in set of books currency
POS_THETA NUMBER

Position Theta
POS_THETA_USD NUMBER

Position Theta in USD currency
POS_THETA_SOB NUMBER

Position Theta in set of books currency
POS_VEGA_USD NUMBER

Position Vega in USD currency
POS_VEGA_SOB NUMBER

Position Vega in set of books currency
YIELD_TO_MATURITY NUMBER

Yield to maturity
LAST_MD_CALC_DATE DATE

Last calculation date for market-data dependent
TRANSACTION_PRICE NUMBER

Transaction Price Deal Currency
TRANSACTION_PRICE_USD NUMBER

Transaction Price USD
TRANSACTION_PRICE_SOB NUMBER

Transaction Price SOB
REVALUATION_PRICE NUMBER

Revaluation Price Deal Currency
REVALUATION_PRICE_USD NUMBER

Revaluation Price USD
REVALUATION_PRICE_SOB NUMBER

Revaluation Price SOB

[top of page]

QRM.QRM_DEAL_CALCULATIONS does not reference any database object

QRM.QRM_DEAL_CALCULATIONS is referenced by following:

QRM
VIEW - QRM_DEAL_CALCULATIONS#

[top of page]

Table: QRM_DEAL_CALC_ERRORS

Description: Error and warning messages for analysis runs
Primary Key: QRM_DEAL_CALC_ERRORS_UK1
  1. ANALYSIS_NAME
  2. DEAL_NO
  3. ERROR_CODE
  4. MARKET_DATA_SET
  5. TRANSACTION_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
QRM_DEAL_CALC_ERRORS.TRANSACTION_NO
QRM_DEAL_CALC_ERRORS.DEAL_NO
QRM_DEAL_CALC_ERRORS.MARKET_DATA_SET 		QRM_DEAL_CALCULATIONS
Comments

QRM_DEAL_CALC_ERRORS saves warning and error messages generated when an analysis is run. An analysis can generate multiple warning messages, but if it generates an error message, the error message will be the only message generated for the analysis.

Indexes
Index Type Tablespace Column
QRM_DEAL_CALC_ERRORS_U1 UNIQUE APPS_TS_TX_IDX ANALYSIS_NAME
DEAL_NO
ERROR_CODE
MARKET_DATA_SET
TRANSACTION_NO
Columns
Name Datatype Length Mandatory Comments
ANALYSIS_NAME VARCHAR2 (20) Y Name of the analysis
DEAL_NO NUMBER

Deal number
TRANSACTION_NO NUMBER

Transaction number
MARKET_DATA_SET VARCHAR2 (20)
Market data set used for calculation.
ERROR_TYPE VARCHAR2 (1) Y Indicates the type of error: 'E' error, or 'W' warning.
ERROR_CODE VARCHAR2 (50) Y Message code
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
REQUEST_ID NUMBER (15)
Concurrent request ID
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent program application ID
PROGRAM_ID NUMBER (15)
Concurrent program ID
PROGRAM_UPDATE_DATE DATE

Concurrent program update date
TOKEN_NAME VARCHAR2 (20)
Name of message token
TOKEN_VALUE VARCHAR2 (80)
Value of message token

[top of page]

QRM.QRM_DEAL_CALC_ERRORS does not reference any database object

QRM.QRM_DEAL_CALC_ERRORS is referenced by following:

QRM
VIEW - QRM_DEAL_CALC_ERRORS#

[top of page]

Table: QRM_FILTERS

Description: Filters Header
Primary Key: QRM_FILTERS_PK
  1. FILTER_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
QRM_ANALYSIS_SETTINGS.FILTER_NAME QRM_FILTERS
QRM_FILTER_CONDITIONS.FILTER_NAME QRM_FILTERS
Comments

QRM_FILTERS contains information about filters used in Risk Management Analyses. Each row
corresponds to a filter and contains a name, description, condition relation, and where clause. Every filter condition must be associated with a filter from this table. The actual details of these filter conditions are stored in QRM_FILTER_CONDITIONS.

Indexes
Index Type Tablespace Column
QRM_FILTERS_U1 UNIQUE APPS_TS_TX_IDX FILTER_NAME
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
FILTER_NAME VARCHAR2 (20) Y Name of the filter
DESCRIPTION VARCHAR2 (50)
Description of the filter
CONDITION_RELATION VARCHAR2 (5) Y Determines whether Risk Analysis uses this set of filter conditions to select deals where all conditions are met (AND) or where at least one condition is met (OR). The values are derived from Fnd_Lookup Type QRM_CONDITION_RELATION
WHERE_CLAUSE VARCHAR2 (2000) Y Where clause formed by the set of filter conditions
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

QRM.QRM_FILTERS does not reference any database object

QRM.QRM_FILTERS is referenced by following:

QRM
VIEW - QRM_FILTERS#

[top of page]

Table: QRM_FILTER_CONDITIONS

Description: Conditions for Filters
Primary Key: QRM_FILTER_CONDITIONS_PK
  1. FILTER_NAME
  2. ROW_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
QRM_FILTER_CONDITIONS.FILTER_NAME QRM_FILTERS
Comments

QRM_FILTER_CONDITIONS contains information about conditions for filters. Each row corresponds
to a condition and is tied to a filter in QRM_FILTERS.

Indexes
Index Type Tablespace Column
QRM_FILTER_CONDITIONS_U1 UNIQUE APPS_TS_TX_IDX FILTER_NAME
ROW_NUMBER
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
FILTER_NAME VARCHAR2 (20) Y Name of the filter
ROW_NUMBER NUMBER (15) Y Unique identifier for each row within the filter
ATTRIBUTE_NAME VARCHAR2 (20) Y Deal attribute name
RELATION VARCHAR2 (3) Y The relation between the deal attribute and its value. The different relation codes and descriptions correspond to the Fnd_Lookup Type QRM_RELATION_TYPE. The following relations are only applicable to those values of type DATE or NUMBER: C (Contains), SW (Starts with), and EW (Ends with).
VALUE VARCHAR2 (30) Y The condition value that relates to the deal attribute. These values can be of type NUMBER, DATE, or STRINGS, but are always converted and stored as VARCHAR2.
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

QRM.QRM_FILTER_CONDITIONS does not reference any database object

QRM.QRM_FILTER_CONDITIONS is referenced by following:

QRM
VIEW - QRM_FILTER_CONDITIONS#

[top of page]

Table: QRM_SAVED_ANALYSES_COL

Description: Column headers and legend that contains necessary information to read QRM_SAVED_ANALYSES_ROW information
Primary Key: QRM_SAVED_ANALYSES_COL_PK
  1. ANALYSIS_NAME
  2. SEQ_NO
Comments

QRM_SAVED_ANALYSES_COL contains information necessary for Risk Analysis to retrieve the relevant information stored in QRM_SAVED_ANALYSES_ROW. By iterating through all the rows in QRM_SAVED_ANALYSES_COL, Risk Analysis dynamically generates a SQL statement that retrieves the applicable rows information from QRM_SAVED_ANALYSES_ROW such that the results of that SQL statement resembles the final analysis results table.This table contains information to determine the column header names of the analysis results table, column data types, whether certain columns are to be displayed in the results table, and others. Each row in this table represents a column in the analysis results table, at least for those rows where the HIDDEN flag is not set to Y.

Indexes
Index Type Tablespace Column
QRM_SAVED_ANALYSES_COL_U1 UNIQUE APPS_TS_TX_IDX ANALYSIS_NAME
SEQ_NO
Columns
Name Datatype Length Mandatory Comments
ANALYSIS_NAME VARCHAR2 (20) Y Name of the analysis
SEQ_NO NUMBER (5) Y Column sequence number. The order of columns displayed in the analysis results.
SEQ_NO_KEY VARCHAR2 (255)
Foreign key to help determine which column sequence number is associated with data in QRM_SAVED_ANALYSES_ROW. This only applies to Crosstab style analyses. SEQ_NO_KEY stores either the attribute names for those attributes that are part of the row aggregation, or the physical column names that are part of the column aggregation. This column cannot be null for Cross-Tab style.
COL_NAME_MAP VARCHAR2 (7) Y Column name of QRM_SAVED_ANALYSES_ROW that this SEQ_NO (column) corresponds to. For example, if SEQ_NO is 2 and COL_NAME_MAP is A2, it means the second column in the analysis results table derives its values from column A2 in QRM_SAVED_ANALYSES_ROW.
TYPE NUMBER (5) Y The type of data saved: -2 = Column Header, -1 = Measure, 1 = Total Level 1. Risk Analysis limits the number of column aggregation levels to 1. The total level represents the level of aggregation for which the sum was calculated. This level is derived from the ORDER column in QRM_ANALYSIS_SETTINGS. For example, if the type is 1, that column contains total information stored in column A1.
HIDDEN VARCHAR2 (1) Y Flag to indicate whether the column is hidden (Y) or not (N).
TOT_CURRENCY VARCHAR2 (20)
Underlying currency for the total of the particular column.
TOT_CURRENCY_LABEL VARCHAR2 (25)
Currency label that appends to the "Total" label to complete the summation labels. For example, if TOT_CURRENCY is 'USD', then the currency label will be ' (USD)'. At run time, the string 'Total' is appended to this label to form 'Total (USD)'.
A1 VARCHAR2 (20)
Value of attributes that can be aggregated.
START_DATE DATE

Date when the time bucket starts.
END_DATE DATE

Date when the time bucket ends.
PERCENT_COL_NAME_MAP VARCHAR2 (7)
Specifies the corresponding column name in QRM_SAVED_ANALYSES_ROW that stores the percentage. For example, a value of P2 means the percentage value for this column in the analysis results table is stored in column P2 in QRM_SAVED_ANLAYSES_ROW. In general, the percentage for column M1 in QRM_SAVED_ANALYSES_ROW is stored in column P1 in QRM_SAVED_ANALYSES_ROW.
CURR_COL_NAME_MAP VARCHAR2 (7)
Specifies the corresponding column name QRM_SAVED_ANALYSES_ROW that stores the underlying currency. For example, a value of CURR2 means the underlying currency for this column in the analysis results is stored in column CURR2 in QRM_SAVED_ANALYSES_ROW. In general, the underlying currency for column M1 in QRM_SAVED_ANALYSES_ROW is stored in column CURR1 in QRM_SAVED_ANALYSES_ROW.
TB_LABEL VARCHAR2 (20)
User defined labels for the time buckets. The labels are stored in the LABEL column in QRM_TIME_INTERVALS.
COL_PERCENT_LEVEL NUMBER (5)
Level of aggregate that the percentage of the measures is based on. This value is analogous to the Total Level concept with the TYPE column.
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

QRM.QRM_SAVED_ANALYSES_COL does not reference any database object

QRM.QRM_SAVED_ANALYSES_COL is referenced by following:

QRM
VIEW - QRM_SAVED_ANALYSES_COL#

[top of page]

Table: QRM_SAVED_ANALYSES_ROW

Description: Rows that are displayed below the column header for Analysis Results.
Primary Key: QRM_SAVED_ANALYSES_ROW_PK
  1. ANALYSIS_NAME
  2. SEQ_NO
Comments

QRM_SAVED_ANALYSES contains data that represents the rows in the analysis results table, except for Table style analysis. Only those analyses that were run and are still listed in the Analysis Manager have their results saved in this table. Each analysis in the Analysis Manager can only have one set of saved data in the table. Moreover, the saved data are saved in the same table format as the actual output to avoid pivoting. Each row corresponds a row in the Analysis Results table.

Indexes
Index Type Tablespace Column
QRM_SAVED_ANALYSES_ROW_U1 UNIQUE APPS_TS_TX_IDX ANALYSIS_NAME
SEQ_NO
Columns
Name Datatype Length Mandatory Comments
ANALYSIS_NAME VARCHAR2 (20) Y Name of the analysis.
SEQ_NO NUMBER (5) Y Row sequence number. The order of rows that are displayed for the analysis results table. Starts from 1.
TYPE NUMBER (5) Y The type of data saved: -1 = Measure, 1 = Total Level 1, 2 = Total Level 2, ... 16 = Total Level 16. Risk Analysis limits the number of row aggregation levels to 16. The total level represents the level of aggregation for which the sum was calculated. This level is derived from the ORDER column in QRM_ANALYSIS_SETTINGS. For example, if the type is 1, this row contains total information stored in column A1. Risk Analysis also uses the type to derive which values in this row corresponds to which results table column.
HIDDEN VARCHAR2 (1) Y Flag to indicate whether the row is hidden (Y) or not (N).
TOT_CURRENCY VARCHAR2 (20)
Underlying currency for the totals in this row.
TOT_CURRENCY_LABEL VARCHAR2 (25)
Currency label that appends to the "Total" label to complete the summation labels. For example, if TOT_CURRENCY is 'USD', then the currency label will be ' (USD)'. At run time, the string 'Total' is appended to this label to form 'Total (USD)'.
A1 VARCHAR2 (20)
Value of attributes that can be aggregated.
A2 VARCHAR2 (20)
Value of attributes that can be aggregated.
A3 VARCHAR2 (20)
Value of attributes that can be aggregated.
A4 VARCHAR2 (20)
Value of attributes that can be aggregated.
A5 VARCHAR2 (20)
Value of attributes that can be aggregated.
A6 VARCHAR2 (20)
Value of attributes that can be aggregated.
A7 VARCHAR2 (20)
Value of attributes that can be aggregated.
A8 VARCHAR2 (20)
Value of attributes that can be aggregated.
A9 VARCHAR2 (20)
Value of attributes that can be aggregated.
A10 VARCHAR2 (20)
Value of attributes that can be aggregated.
A11 VARCHAR2 (20)
Value of attributes that can be aggregated.
A12 VARCHAR2 (20)
Value of attributes that can be aggregated.
A13 VARCHAR2 (20)
Value of attributes that can be aggregated.
A14 VARCHAR2 (20)
Value of attributes that can be aggregated.
A15 VARCHAR2 (20)
Value of attributes that can be aggregated.
A16 VARCHAR2 (20)
Value of attributes that can be aggregated.
M1 NUMBER

Measures
M2 NUMBER

Measures
M3 NUMBER

Measures
M4 NUMBER

Measures
M5 NUMBER

Measures
M6 NUMBER

Measures
M7 NUMBER

Measures
M8 NUMBER

Measures
M9 NUMBER

Measures
M10 NUMBER

Measures
M11 NUMBER

Measures
M12 NUMBER

Measures
M13 NUMBER

Measures
M14 NUMBER

Measures
M15 NUMBER

Measures
M16 NUMBER

Measures
M17 NUMBER

Measures
M18 NUMBER

Measures
M19 NUMBER

Measures
M20 NUMBER

Measures
M21 NUMBER

Measures
M22 NUMBER

Measures
M23 NUMBER

Measures
M24 NUMBER

Measures
M25 NUMBER

Measures
M26 NUMBER

Measures
M27 NUMBER

Measures
M28 NUMBER

Measures
M29 NUMBER

Measures
M30 NUMBER

Measures
M31 NUMBER

Measures
M32 NUMBER

Measures
M33 NUMBER

Measures
M34 NUMBER

Measures
M35 NUMBER

Measures
M36 NUMBER

Measures
M37 NUMBER

Measures
M38 NUMBER

Measures
M39 NUMBER

Measures
M40 NUMBER

Measures
M41 NUMBER

Measures
M42 NUMBER

Measures
M43 NUMBER

Measures
M44 NUMBER

Measures
M45 NUMBER

Measures
M46 NUMBER

Measures
M47 NUMBER

Measures
M48 NUMBER

Measures
M49 NUMBER

Measures
M50 NUMBER

Measures
M51 NUMBER

Measures
M52 NUMBER

Measures
M53 NUMBER

Measures
M54 NUMBER

Measures
M55 NUMBER

Measures
M56 NUMBER

Measures
M57 NUMBER

Measures
M58 NUMBER

Measures
M59 NUMBER

Measures
M60 NUMBER

Measures
M61 NUMBER

Measures
M62 NUMBER

Measures
M63 NUMBER

Measures
M64 NUMBER

Measures
M65 NUMBER

Measures
M66 NUMBER

Measures
M67 NUMBER

Measures
M68 NUMBER

Measures
M69 NUMBER

Measures
M70 NUMBER

Measures
M71 NUMBER

Measures
M72 NUMBER

Measures
M73 NUMBER

Measures
M74 NUMBER

Measures
M75 NUMBER

Measures
M76 NUMBER

Measures
M77 NUMBER

Measures
M78 NUMBER

Measures
M79 NUMBER

Measures
M80 NUMBER

Measures
M81 NUMBER

Measures
M82 NUMBER

Measures
M83 NUMBER

Measures
M84 NUMBER

Measures
M85 NUMBER

Measures
M86 NUMBER

Measures
M87 NUMBER

Measures
M88 NUMBER

Measures
M89 NUMBER

Measures
M90 NUMBER

Measures
M91 NUMBER

Measures
M92 NUMBER

Measures
M93 NUMBER

Measures
M94 NUMBER

Measures
M95 NUMBER

Measures
M96 NUMBER

Measures
M97 NUMBER

Measures
M98 NUMBER

Measures
M99 NUMBER

Measures
M100 NUMBER

Measures
P1 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P2 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P3 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P4 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P5 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P6 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P7 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P8 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P9 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P10 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P11 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P12 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P13 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P14 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P15 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P16 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P17 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P18 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P19 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P20 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P21 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P22 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P23 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P24 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P25 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P26 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P27 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P28 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P29 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P30 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P31 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P32 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P33 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P34 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P35 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P36 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P37 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P38 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P39 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P40 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P41 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P42 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P43 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P44 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P45 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P46 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P47 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P48 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P49 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P50 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P51 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P52 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P53 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P54 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P55 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P56 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P57 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P58 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P59 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P60 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P61 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P62 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P63 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P64 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P65 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P66 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P67 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P68 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P69 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P70 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P71 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P72 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P73 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P74 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P75 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P76 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P77 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P78 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P79 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P80 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P81 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P82 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P83 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P84 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P85 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P86 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P87 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P88 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P89 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P90 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P91 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P92 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P93 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P94 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P95 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P96 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P97 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P98 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P99 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
P100 NUMBER

Percentage for the corresponding measure with respect to Total Level specified in QRM_SAVED_ANALYSES_COL.COL_PERCENT_LEVEL
CURR1 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR2 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR3 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR4 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR5 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR6 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR7 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR8 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR9 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR10 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR11 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR12 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR13 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR14 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR15 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR16 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR17 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR18 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR19 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR20 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR21 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR22 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR23 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR24 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR25 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR26 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR27 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR28 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR29 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR30 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR31 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR32 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR33 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR34 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR35 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR36 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR37 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR38 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR39 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR40 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR41 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR42 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR43 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR44 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR45 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR46 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR47 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR48 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR49 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR50 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR51 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR52 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR53 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR54 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR55 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR56 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR57 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR58 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR59 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR60 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR61 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR62 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR63 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR64 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR65 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR66 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR67 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR68 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR69 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR70 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR71 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR72 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR73 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR74 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR75 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR76 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR77 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR78 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR79 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR80 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR81 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR82 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR83 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR84 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR85 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR86 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR87 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR88 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR89 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR90 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR91 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR92 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR93 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR94 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR95 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR96 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR97 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR98 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR99 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CURR100 VARCHAR2 (20)
Underlying currency for the Underlying currency for the corresponding measure.
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

QRM.QRM_SAVED_ANALYSES_ROW does not reference any database object

QRM.QRM_SAVED_ANALYSES_ROW is referenced by following:

QRM
VIEW - QRM_SAVED_ANALYSES_ROW#

[top of page]

Table: QRM_TB_CALCULATIONS

Description: Calculated deal attributes that can change over time.
Primary Key: QRM_TB_CALCULATIONS_UK1
  1. DEAL_NO
  2. END_DATE
  3. START_DATE
  4. MARKET_DATA_SET
  5. TRANSACTION_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
QRM_TB_CALCULATIONS.TRANSACTION_NO
QRM_TB_CALCULATIONS.DEAL_NO
QRM_TB_CALCULATIONS.MARKET_DATA_SET 		QRM_DEAL_CALCULATIONS
Comments

QRM_TB_CALCULATIONS contain calculated deal attributes for current deals that change over time. These attributes include values such as outstanding amount, coupon rate, next coupon date, and so on. Each row corresponds to deal attribute values within a fixed time period.

Indexes
Index Type Tablespace Column
QRM_TB_CALCULATIONS_U1 UNIQUE APPS_TS_TX_IDX DEAL_NO
TRANSACTION_NO
MARKET_DATA_SET
START_DATE
END_DATE
QRM_TB_CALCULATIONS_N1 NONUNIQUE APPS_TS_TX_IDX START_DATE
QRM_TB_CALCULATIONS_N2 NONUNIQUE APPS_TS_TX_IDX END_DATE
QRM_TB_CALCULATIONS_N3 NONUNIQUE APPS_TS_TX_IDX POS_START_DATE
QRM_TB_CALCULATIONS_N4 NONUNIQUE APPS_TS_TX_IDX POS_END_DATE
Columns
Name Datatype Length Mandatory Comments
DEAL_NO NUMBER
Y Deal number.
TRANSACTION_NO NUMBER
Y Transaction number.
MARKET_DATA_SET VARCHAR2 (20) Y Market data set used for calculation.
START_DATE DATE

Start date of time bucket
END_DATE DATE
Y End date of time bucket
INTEREST_BASIS VARCHAR2 (1)
Interest basis
OUTSTANDING_AMOUNT NUMBER

Amount outstanding for time bucket period.
OUTSTANDING_AMOUNT_USD NUMBER

Amount outstanding in USD currency.
OUTSTANDING_AMOUNT_SOB NUMBER

Amount outstanding in set of books currency.
COUPON_RATE NUMBER

Coupon rate for time bucket period.
NEXT_COUPON_DATE DATE

Next coupon date
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
REQUEST_ID NUMBER (15)
Concurrency request id
PROGRAM_APPLICATION_ID NUMBER (15)
Program application_id
PROGRAM_ID NUMBER (15)
Program id
PROGRAM_UPDATE_DATE DATE

Program update date
POS_START_DATE DATE

Position start date
POS_END_DATE DATE

Position end date
AMT_QTY_OUT NUMBER

Amount or Quantity Outstanding
AMT_QTY_OUT_USD NUMBER

Amount or Quantity Outstanding USD
AMT_QTY_OUT_SOB NUMBER

Amount or Quantity Outstanding SOB

[top of page]

QRM.QRM_TB_CALCULATIONS does not reference any database object

QRM.QRM_TB_CALCULATIONS is referenced by following:

QRM
VIEW - QRM_TB_CALCULATIONS#

[top of page]

Table: QRM_TIME_BUCKETS

Description: Time Buckets header
Primary Key: QRM_TIME_BUCKETS_PK
  1. TB_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
QRM_ANALYSIS_SETTINGS.TB_NAME QRM_TIME_BUCKETS
QRM_TIME_INTERVALS.TB_NAME QRM_TIME_BUCKETS
Comments

QRM_TIME_BUCKETS contains information about the time buckets that are used in Risk anagement Analyses. Each row in the table corresponds to a set of time buckets and contains a name and description for the set of time buckets. Each row is also associated with several time intervals that comprise the set of time buckets. The details for each of the intervals are stored in QRM_TIME_INTERVALS.

Indexes
Index Type Tablespace Column
QRM_TIME_BUCKETS_U1 UNIQUE APPS_TS_TX_IDX TB_NAME
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
TB_NAME VARCHAR2 (20) Y Name of the time buckets
DESCRIPTION VARCHAR2 (50)
Name of the time buckets
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

QRM.QRM_TIME_BUCKETS does not reference any database object

QRM.QRM_TIME_BUCKETS is referenced by following:

QRM
VIEW - QRM_TIME_BUCKETS#

[top of page]

Table: QRM_TIME_INTERVALS

Description: Time Intervals for Time Buckets
Primary Key: QRM_TIME_INTERVALS_PK
  1. SEQUENCE_NUMBER
  2. TB_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
QRM_TIME_INTERVALS.TB_NAME QRM_TIME_BUCKETS
Comments

QRM_TIME_INTERVALS contains information about the time intervals that are associated with a set of time buckets. Each row corresponds to a time interval and is tied to time buckets in QRM_TIME_BUCKETS.

Indexes
Index Type Tablespace Column
QRM_TIME_INTERVALS_N1 UNIQUE APPS_TS_TX_IDX TB_NAME
SEQUENCE_NUMBER
ZD_EDITION_NAME
QRM_TIME_INTERVALS_U1 UNIQUE APPS_TS_TX_IDX SEQUENCE_NUMBER
TB_NAME
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
TB_NAME VARCHAR2 (20) Y Name of the time buckets
SEQUENCE_NUMBER NUMBER
Y The order of time intervals in the time buckets
INTERVAL_LENGTH NUMBER

The number defining the time interval length
INTERVAL_TYPE VARCHAR2 (3)
The time unit defining the time interval length. The values are derived from Fnd_Lookup Type QRM_PERIOD_LENGTH
LABEL VARCHAR2 (20)
Description of the time interval
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

QRM.QRM_TIME_INTERVALS does not reference any database object

QRM.QRM_TIME_INTERVALS is referenced by following:

QRM
VIEW - QRM_TIME_INTERVALS#

[top of page]

View: QRM_ANALYSIS_DEALS_V

Comments
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.

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) Y Refer to base table or view
DEAL_TYPE VARCHAR2 (7) Y 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
Y Refer to base table or view
TRANSACTION_NO VARCHAR2 (40)
Refer to base table or view
MARKET_DATA_SET VARCHAR2 (20) Y 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
Y 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

[top of page]

APPS.QRM_ANALYSIS_DEALS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - QRM_DEAL_CALCULATIONS
SYNONYM - XTR_DEAL_SUBTYPES
SYNONYM - XTR_DEAL_TYPES
- QRM_CURRENT_DEALS_V

APPS.QRM_ANALYSIS_DEALS_V is not referenced by any database object

[top of page]

View: QRM_ANALYSIS_DISC_V

Comments
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.

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) Y Refer to base table or view
DEAL_TYPE VARCHAR2 (7) Y 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
Y Refer to base table or view
TRANSACTION_NO VARCHAR2 (40)
Refer to base table or view
MARKET_DATA_SET VARCHAR2 (20) Y 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
Y 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

[top of page]

APPS.QRM_ANALYSIS_DISC_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - QRM_DEAL_CALCULATIONS
SYNONYM - QRM_TB_CALCULATIONS
SYNONYM - XTR_DEAL_SUBTYPES
SYNONYM - XTR_DEAL_TYPES
- QRM_CURRENT_DEALS_V

APPS.QRM_ANALYSIS_DISC_V is not referenced by any database object

[top of page]

View: QRM_CURRENT_DEALS_V

Comments
View Type

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

The QRM_CURRENT_DEALS_V view shows the deals and deal attributes mapping from
the XTR_DEALS and the XTR_ROLLOVER_TRANSACTIONS tables. This view includes
these deal types: ONC, FX, FXO, BDO, BOND, FRA, IRO, IRS, NI, RTMM, SWPTN,
TMM, and IG. ONC deals are available on a transaction level, while all other
deal types are available on a deal level. This view shows only those deals
that are in CURRENT status. Because this view also filters on the user access
to certain companies (defined in Treasury User Access Level form), the deals
shown for one user may only be the subset of all the available deals.

Columns
Name Datatype Length Mandatory Comments
DEAL_NO NUMBER

Refer to base table
TRANSACTION_NO NUMBER

Refer to base table
MARKET_DATA_SET VARCHAR2 (30)
Refer to base table
CALL_OR_PUT VARCHAR2 (5)
Refer to base table
OPTION_STYLE VARCHAR2 (8)
If start date is NULL, then AMERICAN for American. Else EUROPEAN for European.
ISSUER_CODE VARCHAR2 (7)
Code of security issuer
COMPANY_CODE VARCHAR2 (7)
Refer to base table
DEALER_CODE VARCHAR2 (10)
Refer to base table
CLIENT_CODE VARCHAR2 (7)
Refer to base table
CPARTY_CODE VARCHAR2 (7)
Refer to base table
PORTFOLIO_CODE VARCHAR2 (7)
Refer to base table
LINK_CODE VARCHAR2 (8)
Refer to base table
PRICING_MODEL VARCHAR2 (13)
If deal type is BOND: MARKET,NI: DISC_METHOD,TMM: DISC_CASHFLOW,IRS: DISC_CASHFLOW,IRO: BLACK
DEAL_CCY VARCHAR2 (15)
Deal currency of money market deals, null for foreign exchange deals.
BUY_CCY VARCHAR2 (15)
Refer to base table
SELL_CCY VARCHAR2 (15)
Refer to base table
FOREIGN_CCY VARCHAR2 (15)
Refer to base table
DOMESTIC_CCY VARCHAR2 (15)
Refer to base table
BASE_CCY VARCHAR2 (15)
Base currency of foreign exchange deals.
CONTRA_CCY VARCHAR2 (15)
Contra currency of foreign exchange deals
SENSITIVITY_CCY VARCHAR2 (15)
Null for IG deals, deal currency for other money market deals, set of books currency for FX deals , and premium currency for FXO deals
PREMIUM_CCY VARCHAR2 (15)
Refer to base table
BUY_AMOUNT NUMBER

Refer to base table
SELL_AMOUNT NUMBER

Refer to base table
FOREIGN_AMOUNT NUMBER

For foreign exchange deals only. If the foreign currency is equal to buy currency, this field is the buy currency amount. If the foreign currency is equal to the sell currency, this field is the sell currency amount
DOMESTIC_AMOUNT NUMBER

For foreign exchange deals only. If the domestic currency is equal to buy currency, this field is the buy currency amount. If the domestic currency is equal to the sell currency, this field is the sell currency amount
BASE_CCY_AMOUNT NUMBER

Base currency amount of foreign exchange deals
CONTRA_CCY_AMOUNT NUMBER

Contra currency amount of foreign exchange deals
START_AMOUNT NUMBER

Refer to base table
FACE_VALUE NUMBER

If deal type is ONC: transaction balance out,BDO, FRA, IRO, IRS, RTMM, SWPTN, TMM, FX, FXO: deal face value amount,BOND, NI: deal maturity balance amount,IG: deal balance out
INTEREST NUMBER

Refer to base table
ACCUM_INTEREST_BF NUMBER

Refer to base table
ACCUM_INT_ACTION VARCHAR2 (7)
Refer to base table
ACCRUED_INTEREST NUMBER

If deal type is BOND : accrued interest price,IG: sum of accumulated interest brought forward and interest
INTEREST_SETTLED NUMBER

Refer to base table
DEAL_DATE DATE

Refer to base table
END_DATE DATE

If deal type is ONC, BOND, IRS, NI, RTMM, TMM: deal maturity date,BDO, IRO, FXO, SWPTN: deal expiry date, FX: deal value date,IG: NULL
GAP_DATE DATE

If deal type is ONC: NULL, BOND, NI: deal maturity date,BDO, IRO, SWPTN: deal expiry date,FRA: deal start date. For all other deals: NULL-
DEAL_SUBTYPE VARCHAR2 (7)
Refer to base table
DEAL_TYPE VARCHAR2 (7)
Refer to base table
DISCOUNT_YIELD VARCHAR2 (1)
Refer to base table
EXPIRATION_DATE DATE

Refer to base table
MATURITY_DATE DATE

Refer to base table
NO_OF_DAYS NUMBER

Refer to base table
MARKET_TYPE VARCHAR2 (1)
M for money market deals . F for foreign exchange deals
INSTR_TYPE VARCHAR2 (1)
If deal type is FXO, IRO, FRA, IRS, SWPTN, BDO, then D for derivative, otherwise P for physical
MM_FX_INSTR_TYPE VARCHAR2 (1)
For IRS, FRA, IRO, BDO, SWPTN deals: D for derivative. For IG deals: If action is REC, then F for fund, else I for invest. For all other MM deals: If deal subtype is ISSUE or SELL, then F for fund. Otherwise I for invest
VALUE_DATE DATE

Refer to base table
SETTLE_DATE DATE

Refer to base table
PREMIUM_AMOUNT NUMBER

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

Refer to base table
PHY_START_DATE DATE

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

Refer to base table
KNOCK_EXECUTE_DATE DATE

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

Refer to base table
COUPON_ACTION VARCHAR2 (3)
Refer to base table
COUPON_RATE NUMBER

If deal type is SWPTN, IRO, NI, IG: deal interest rate,ONC: transaction interest rate. For all other deals: coupon rate
MARGIN NUMBER

Refer to base table
TRANSACTION_RATE NUMBER

If deal type is FRA, IRO, IRS, NI, RTMM, SWPTN, TMM, IG: deal interest rate,ONC: transaction interest rate,BOND, BDO: deal capital price
INTEREST_FREQUENCY VARCHAR2 (1)
Refer to base table
COUPON_FREQUENCY NUMBER

Denotes no of coupons per year
NEXT_COUPON_DATE DATE

Refer to base table
DAY_COUNT_BASIS VARCHAR2 (15)
Refer to base table
QUANTITY_REMAINING NUMBER

Refer to base table
QUANTITY_REMAINING_USD NUMBER

Refer to base table
QUANTITY_REMAINING_SOB NUMBER

Refer to base table
ROUNDING_TYPE VARCHAR2 (1)
Refer to base table
DAY_COUNT_TYPE VARCHAR2 (1)
Refer to base table
PREPAID_INTEREST VARCHAR2 (1)
Refer to base table

[top of page]

APPS.QRM_CURRENT_DEALS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - XTR_BOND_ISSUES
SYNONYM - XTR_BUY_SELL_COMBINATIONS
SYNONYM - XTR_COMPANY_AUTHORITIES
SYNONYM - XTR_DEALER_CODES
SYNONYM - XTR_DEALS
SYNONYM - XTR_INTERGROUP_TRANSFERS
SYNONYM - XTR_ROLLOVER_TRANSACTIONS
- XTR_TY_SUB_PRD_COMBIN_V
APPS.QRM_CURRENT_DEALS_V is referenced by following:

APPS
VIEW - QRM_DISC_ANALYSIS_TB_V
VIEW - QRM_DISC_ANALYSIS_V

[top of page]

View: QRM_DISC_ANALYSIS_TB_V

Comments
View Type

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

The QRM_DISC_ANALYSIS_TB_V view lets a reporting tool, such
as Oracle Discoverer, generate reports similar to crosstab with time bucket
analysis. The QRM_DISC_ANALYSIS_TB_V view only generates sensible data if the
TB_END_DATE column or the TB_START_DATE column is included in the set of group
by columns. The result displays the progression of aggregated measures across
time. If the time bucket time element is left out of any aggregation,
summarized amounts are double counted. If you use views such as
QRM_ANALYSIS_DISC_V, you must first set up and run crosstab with time buckets
analysis before this view picks up data, and rerun the analysis each time you
wish to refresh this data. User access to company information is enforced in
the QRM_DISC_ANALYSIS_TB_V view.

Columns
Name Datatype Length Mandatory Comments
ANALYSIS_NAME VARCHAR2 (20) Y Refer to base table or view
TB_START_DATE DATE

Refer to base table or view
TB_END_DATE DATE

Refer to base table or view
DEAL_NO NUMBER

Refer to base table or view
TRANSACTION_NO NUMBER

Refer to base table or view
MARKET_DATA_SET VARCHAR2 (30)
Refer to base table or view
CALL_OR_PUT VARCHAR2 (5)
Refer to base table or view
OPTION_STYLE VARCHAR2 (8)
Refer to base table or view
ISSUER_CODE VARCHAR2 (7)
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
DEAL_CCY VARCHAR2 (15)
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
SENSITIVITY_CCY VARCHAR2 (15)
Refer to base table or view
PREMIUM_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
START_AMOUNT NUMBER

Refer to base table or view
FACE_VALUE NUMBER

Refer to base table or view
INTEREST NUMBER

Refer to base table or view
ACCUM_INTEREST_BF NUMBER

Refer to base table or view
ACCUM_INT_ACTION VARCHAR2 (7)
Refer to base table or view
ACCRUED_INTEREST_PRICE NUMBER

Refer to base table or view
INTEREST_SETTLED 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) Y Refer to base table or view
DEAL_TYPE VARCHAR2 (7) Y Refer to base table or view
DISCOUNT_YIELD VARCHAR2 (1)
Refer to base table or view
EXPIRATION_DATE DATE

Refer to base table or view
MATURITY_DATE DATE

Refer to base table or view
NO_OF_DAYS NUMBER

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
SETTLE_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
PHY_START_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
KNOCK_EXECUTE_DATE DATE

Refer to base table or view
INITIAL_BASIS VARCHAR2 (5)
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
COUPON_ACTION VARCHAR2 (3)
Refer to base table or view
MARGIN NUMBER

Refer to base table or view
TRANSACTION_RATE NUMBER

Refer to base table or view
INTEREST_FREQUENCY VARCHAR2 (1)
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
QUANTITY_REMAINING NUMBER

Refer to base table or view
QUANTITY_REMAINING_USD NUMBER

Refer to base table or view
QUANTITY_REMAINING_SOB NUMBER

Refer to base table or view
ROUNDING_TYPE VARCHAR2 (1)
Refer to base table or view
DAY_COUNT_TYPE VARCHAR2 (1)
Refer to base table or view
PREPAID_INTEREST VARCHAR2 (1)
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
Y 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_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
POS_VEGA_USD NUMBER

Refer to base table or view
POS_VEGA_SOB NUMBER

Refer to base table or view
YIELD_TO_MATURITY NUMBER

Refer to base table or view
LAST_MD_CALC_DATE DATE

Refer to base table or view
TRANSACTION_PRICE NUMBER

Refer to base table or view
TRANSACTION_PRICE_USD NUMBER

Refer to base table or view
TRANSACTION_PRICE_SOB NUMBER

Refer to base table or view
REVALUATION_PRICE NUMBER

Refer to base table or view
REVALUATION_PRICE_USD NUMBER

Refer to base table or view
REVALUATION_PRICE_SOB 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
OUTSTANDING_AMOUNT_USD NUMBER

Refer to base table or view
OUTSTANDING_AMOUNT_SOB 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
AMT_QTY_OUT NUMBER

Refer to base table or view
AMT_QTY_OUT_USD NUMBER

Refer to base table or view
AMT_QTY_OUT_SOB NUMBER

Refer to base table or view
COMPANY_NAME VARCHAR2 (50) Y Refer to base table or view
CPARTY_NAME VARCHAR2 (50)
Refer to base table or view
DEAL_SUBTYPE_NAME VARCHAR2 (80) Y Refer to base table or view
DEAL_TYPE_NAME VARCHAR2 (80) Y Refer to base table or view
PRODUCT_TYPE_DESC VARCHAR2 (80)
Refer to base table or view

[top of page]

APPS.QRM_DISC_ANALYSIS_TB_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - QRM_CURRENT_DEALS_V
SYNONYM - QRM_DEALS_ANALYSES
SYNONYM - QRM_DEAL_CALCULATIONS
SYNONYM - QRM_SAVED_ANALYSES_COL
SYNONYM - QRM_TB_CALCULATIONS
SYNONYM - XTR_DEAL_SUBTYPES
SYNONYM - XTR_DEAL_TYPES
SYNONYM - XTR_PARTY_INFO
SYNONYM - XTR_PRODUCT_TYPES

APPS.QRM_DISC_ANALYSIS_TB_V is not referenced by any database object

[top of page]

View: QRM_DISC_ANALYSIS_V

Comments
View Type

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

The QRM_DISC_ANALYSIS_V view is used for Discoverer
workbooks and is based on QRM_ANALYSIS_TB_DISC_V view. User access to company
information is enforced in the QRM_DISC_ANALYSIS_V view. The
QRM_DISC_ANALYSIS_V view shows the analyses and their respective deals
analogous to an Oracle Risk Management Table style report. QRM_DISC_ANALYSIS_V
joins the deals information in QRM_ANALYSIS_TB_DISC_V view with the Analyses
Names in QRM_DEALS_ANALYSES table.

Columns
Name Datatype Length Mandatory Comments
ANALYSIS_NAME VARCHAR2 (20) Y Refer to base table or view
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
USER_DEAL_SUBTYPE VARCHAR2 (7) Y Refer to base table or view
USER_DEAL_TYPE VARCHAR2 (7) Y 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
Y Refer to base table or view
TRANSACTION_NO VARCHAR2 (40)
Refer to base table or view
MARKET_DATA_SET VARCHAR2 (20) Y 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
Y 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
OUTSTANDING_AMOUNT_SOB NUMBER

Refer to base table or view
OUTSTANDING_AMOUNT_USD NUMBER

Refer to base table or view
COMPANY_NAME VARCHAR2 (50) Y Refer to base table or view
CPARTY_NAME VARCHAR2 (50)
Refer to base table or view
DEAL_SUBTYPE_NAME VARCHAR2 (80) Y Refer to base table or view
DEAL_TYPE_NAME VARCHAR2 (80) Y Refer to base table or view
PRODUCT_TYPE_DESC VARCHAR2 (80)
Refer to base table or view

[top of page]

APPS.QRM_DISC_ANALYSIS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - QRM_CURRENT_DEALS_V
SYNONYM - QRM_DEALS_ANALYSES
SYNONYM - QRM_DEAL_CALCULATIONS
SYNONYM - QRM_TB_CALCULATIONS
SYNONYM - XTR_DEAL_SUBTYPES
SYNONYM - XTR_DEAL_TYPES
SYNONYM - XTR_PARTY_INFO
SYNONYM - XTR_PRODUCT_TYPES

APPS.QRM_DISC_ANALYSIS_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract