[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | QRM_DISC_ANALYSIS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  QRM.QRM_DISC_ANALYSIS_V
|
| Subobject Name: | |
| Status: | VALID |
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.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ANALYSIS_NAME | VARCHAR2 | (20) | Yes | 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) | Yes | Refer to base table or view |
| USER_DEAL_TYPE | VARCHAR2 | (7) | Yes | Refer to base table or view |
| EXPIRATION_DATE | DATE | Refer to base table or view | ||
| MATURITY_DATE | DATE | Refer to base table or view | ||
| MARKET_TYPE | VARCHAR2 | (1) | Refer to base table or view | |
| INSTR_TYPE | VARCHAR2 | (1) | Refer to base table or view | |
| MM_FX_INSTR_TYPE | VARCHAR2 | (1) | Refer to base table or view | |
| VALUE_DATE | DATE | Refer to base table or view | ||
| PREMIUM_AMOUNT | NUMBER | Refer to base table or view | ||
| PRODUCT_TYPE | VARCHAR2 | (10) | Refer to base table or view | |
| START_DATE | DATE | Refer to base table or view | ||
| KNOCK_EXECUTE_DATE | DATE | Refer to base table or view | ||
| KNOCK_TYPE | VARCHAR2 | (10) | Refer to base table or view | |
| KNOCK_LEVEL | NUMBER | Refer to base table or view | ||
| INT_SWAP_REF | VARCHAR2 | (10) | Refer to base table or view | |
| INT_REF | VARCHAR2 | (20) | Refer to base table or view | |
| BOND_ISSUE_CODE | VARCHAR2 | (30) | Refer to base table or view | |
| SECURITY_ID | VARCHAR2 | (15) | Refer to base table or view | |
| REF_SPOT_RATE | NUMBER | Refer to base table or view | ||
| MARGIN | NUMBER | Refer to base table or view | ||
| COUPON_FREQUENCY | NUMBER | Refer to base table or view | ||
| DAY_COUNT_BASIS | VARCHAR2 | (15) | Refer to base table or view | |
| DEAL_NO | NUMBER | Yes | Refer to base table or view | |
| TRANSACTION_NO | VARCHAR2 | (40) | Refer to base table or view | |
| MARKET_DATA_SET | VARCHAR2 | (20) | Yes | Refer to base table or view |
| DEAL_CCY | VARCHAR2 | (15) | Refer to base table or view | |
| SOB_CCY | VARCHAR2 | (15) | Refer to base table or view | |
| BASE_CCY_AMOUNT_USD | NUMBER | Refer to base table or view | ||
| BASE_CCY_AMOUNT_SOB | NUMBER | Refer to base table or view | ||
| CONTRA_CCY_AMOUNT_USD | NUMBER | Refer to base table or view | ||
| CONTRA_CCY_AMOUNT_SOB | NUMBER | Refer to base table or view | ||
| FOREIGN_AMOUNT_USD | NUMBER | Refer to base table or view | ||
| FOREIGN_AMOUNT_SOB | NUMBER | Refer to base table or view | ||
| DOMESTIC_AMOUNT_USD | NUMBER | Refer to base table or view | ||
| DOMESTIC_AMOUNT_SOB | NUMBER | Refer to base table or view | ||
| BUY_AMOUNT_USD | NUMBER | Refer to base table or view | ||
| BUY_AMOUNT_SOB | NUMBER | Refer to base table or view | ||
| SELL_AMOUNT_USD | NUMBER | Refer to base table or view | ||
| SELL_AMOUNT_SOB | NUMBER | Refer to base table or view | ||
| DAYS | NUMBER | Yes | Refer to base table or view | |
| FX_REVAL_RATE | NUMBER | Refer to base table or view | ||
| MM_REVAL_RATE | NUMBER | Refer to base table or view | ||
| FX_TRANS_RATE | NUMBER | Refer to base table or view | ||
| MM_TRANS_RATE | NUMBER | Refer to base table or view | ||
| FAIR_VALUE | NUMBER | Refer to base table or view | ||
| FAIR_VALUE_USD | NUMBER | Refer to base table or view | ||
| FAIR_VALUE_SOB | NUMBER | Refer to base table or view | ||
| GAP_AMOUNT | NUMBER | Refer to base table or view | ||
| GAP_AMOUNT_USD | NUMBER | Refer to base table or view | ||
| GAP_AMOUNT_SOB | NUMBER | Refer to base table or view | ||
| MATURITY_AMOUNT | NUMBER | Refer to base table or view | ||
| MATURITY_AMOUNT_USD | NUMBER | Refer to base table or view | ||
| MATURITY_AMOUNT_SOB | NUMBER | Refer to base table or view | ||
| PREMIUM_AMOUNT_USD | NUMBER | Refer to base table or view | ||
| PREMIUM_AMOUNT_SOB | NUMBER | Refer to base table or view | ||
| ACCRUED_INTEREST | NUMBER | Refer to base table or view | ||
| ACCRUED_INTEREST_USD | NUMBER | Refer to base table or view | ||
| ACCRUED_INTEREST_SOB | NUMBER | Refer to base table or view | ||
| DURATION | NUMBER | Refer to base table or view | ||
| MODIFIED_DURATION | NUMBER | Refer to base table or view | ||
| CONVEXITY | NUMBER | Refer to base table or view | ||
| DELTA | NUMBER | Refer to base table or view | ||
| GAMMA | NUMBER | Refer to base table or view | ||
| THETA | NUMBER | Refer to base table or view | ||
| RHO_FOREIGN | NUMBER | Refer to base table or view | ||
| RHO_DOMESTIC | NUMBER | Refer to base table or view | ||
| VEGA | NUMBER | Refer to base table or view | ||
| POS_BPV | NUMBER | Refer to base table or view | ||
| POS_DELTA | NUMBER | Refer to base table or view | ||
| POS_GAMMA | NUMBER | Refer to base table or view | ||
| POS_RHO_FOREIGN | NUMBER | Refer to base table or view | ||
| POS_RHO_DOMESTIC | NUMBER | Refer to base table or view | ||
| POS_VEGA | NUMBER | Refer to base table or view | ||
| VOLATILITY | NUMBER | Refer to base table or view | ||
| GAP_DATE | DATE | Refer to base table or view | ||
| RHO | NUMBER | Refer to base table or view | ||
| RHO_BASE | NUMBER | Refer to base table or view | ||
| RHO_CONTRA | NUMBER | Refer to base table or view | ||
| POS_RHO | NUMBER | Refer to base table or view | ||
| POS_RHO_USD | NUMBER | Refer to base table or view | ||
| POS_RHO_SOB | NUMBER | Refer to base table or view | ||
| POS_RHO_BASE | NUMBER | Refer to base table or view | ||
| POS_RHO_BASE_USD | NUMBER | Refer to base table or view | ||
| POS_RHO_BASE_SOB | NUMBER | Refer to base table or view | ||
| POS_RHO_CONTRA | NUMBER | Refer to base table or view | ||
| POS_RHO_CONTRA_USD | NUMBER | Refer to base table or view | ||
| POS_RHO_CONTRA_SOB | NUMBER | Refer to base table or view | ||
| POS_RHO_FOREIGN_USD | NUMBER | Refer to base table or view | ||
| POS_RHO_FOREIGN_SOB | NUMBER | Refer to base table or view | ||
| POS_RHO_DOMESTIC_USD | NUMBER | Refer to base table or view | ||
| POS_RHO_DOMESTIC_SOB | NUMBER | Refer to base table or view | ||
| POS_BPV_USD | NUMBER | Refer to base table or view | ||
| POS_BPV_SOB | NUMBER | Refer to base table or view | ||
| POS_DELTA_USD | NUMBER | Refer to base table or view | ||
| POS_DELTA_SOB | NUMBER | Refer to base table or view | ||
| POS_GAMMA_USD | NUMBER | Refer to base table or view | ||
| POS_GAMMA_SOB | NUMBER | Refer to base table or view | ||
| POS_VEGA_USD | NUMBER | Refer to base table or view | ||
| POS_VEGA_SOB | NUMBER | Refer to base table or view | ||
| POS_THETA | NUMBER | Refer to base table or view | ||
| POS_THETA_USD | NUMBER | Refer to base table or view | ||
| POS_THETA_SOB | NUMBER | Refer to base table or view | ||
| YIELD_TO_MATURITY | NUMBER | Refer to base table or view | ||
| INTEREST_BASIS | VARCHAR2 | (1) | Refer to base table or view | |
| OUTSTANDING_AMOUNT | NUMBER | Refer to base table or view | ||
| COUPON_RATE | NUMBER | Refer to base table or view | ||
| NEXT_COUPON_DATE | DATE | Refer to base table or view | ||
| OUTSTANDING_AMOUNT_SOB | NUMBER | Refer to base table or view | ||
| OUTSTANDING_AMOUNT_USD | NUMBER | Refer to base table or view | ||
| COMPANY_NAME | VARCHAR2 | (50) | Yes | Refer to base table or view |
| CPARTY_NAME | VARCHAR2 | (50) | Refer to base table or view | |
| DEAL_SUBTYPE_NAME | VARCHAR2 | (80) | Yes | Refer to base table or view |
| DEAL_TYPE_NAME | VARCHAR2 | (80) | Yes | Refer to base table or view |
| PRODUCT_TYPE_DESC | VARCHAR2 | (80) | Refer to base table or view |
Cut, paste (and edit) the following text to query this object:
SELECT ANALYSIS_NAME
, CALL_OR_PUT
, OPTION_STYLE
, COMPANY_CODE
, DEALER_CODE
, CLIENT_CODE
, CPARTY_CODE
, PORTFOLIO_CODE
, LINK_CODE
, PRICING_MODEL
, BUY_CCY
, SELL_CCY
, FOREIGN_CCY
, DOMESTIC_CCY
, BASE_CCY
, CONTRA_CCY
, BUY_AMOUNT
, SELL_AMOUNT
, FOREIGN_AMOUNT
, DOMESTIC_AMOUNT
, BASE_CCY_AMOUNT
, CONTRA_CCY_AMOUNT
, DEAL_DATE
, END_DATE
, USER_DEAL_SUBTYPE
, USER_DEAL_TYPE
, EXPIRATION_DATE
, MATURITY_DATE
, MARKET_TYPE
, INSTR_TYPE
, MM_FX_INSTR_TYPE
, VALUE_DATE
, PREMIUM_AMOUNT
, PRODUCT_TYPE
, START_DATE
, KNOCK_EXECUTE_DATE
, KNOCK_TYPE
, KNOCK_LEVEL
, INT_SWAP_REF
, INT_REF
, BOND_ISSUE_CODE
, SECURITY_ID
, REF_SPOT_RATE
, MARGIN
, COUPON_FREQUENCY
, DAY_COUNT_BASIS
, DEAL_NO
, TRANSACTION_NO
, MARKET_DATA_SET
, DEAL_CCY
, SOB_CCY
, BASE_CCY_AMOUNT_USD
, BASE_CCY_AMOUNT_SOB
, CONTRA_CCY_AMOUNT_USD
, CONTRA_CCY_AMOUNT_SOB
, FOREIGN_AMOUNT_USD
, FOREIGN_AMOUNT_SOB
, DOMESTIC_AMOUNT_USD
, DOMESTIC_AMOUNT_SOB
, BUY_AMOUNT_USD
, BUY_AMOUNT_SOB
, SELL_AMOUNT_USD
, SELL_AMOUNT_SOB
, DAYS
, FX_REVAL_RATE
, MM_REVAL_RATE
, FX_TRANS_RATE
, MM_TRANS_RATE
, FAIR_VALUE
, FAIR_VALUE_USD
, FAIR_VALUE_SOB
, GAP_AMOUNT
, GAP_AMOUNT_USD
, GAP_AMOUNT_SOB
, MATURITY_AMOUNT
, MATURITY_AMOUNT_USD
, MATURITY_AMOUNT_SOB
, PREMIUM_AMOUNT_USD
, PREMIUM_AMOUNT_SOB
, ACCRUED_INTEREST
, ACCRUED_INTEREST_USD
, ACCRUED_INTEREST_SOB
, DURATION
, MODIFIED_DURATION
, CONVEXITY
, DELTA
, GAMMA
, THETA
, RHO_FOREIGN
, RHO_DOMESTIC
, VEGA
, POS_BPV
, POS_DELTA
, POS_GAMMA
, POS_RHO_FOREIGN
, POS_RHO_DOMESTIC
, POS_VEGA
, VOLATILITY
, GAP_DATE
, RHO
, RHO_BASE
, RHO_CONTRA
, POS_RHO
, POS_RHO_USD
, POS_RHO_SOB
, POS_RHO_BASE
, POS_RHO_BASE_USD
, POS_RHO_BASE_SOB
, POS_RHO_CONTRA
, POS_RHO_CONTRA_USD
, POS_RHO_CONTRA_SOB
, POS_RHO_FOREIGN_USD
, POS_RHO_FOREIGN_SOB
, POS_RHO_DOMESTIC_USD
, POS_RHO_DOMESTIC_SOB
, POS_BPV_USD
, POS_BPV_SOB
, POS_DELTA_USD
, POS_DELTA_SOB
, POS_GAMMA_USD
, POS_GAMMA_SOB
, POS_VEGA_USD
, POS_VEGA_SOB
, POS_THETA
, POS_THETA_USD
, POS_THETA_SOB
, YIELD_TO_MATURITY
, INTEREST_BASIS
, OUTSTANDING_AMOUNT
, COUPON_RATE
, NEXT_COUPON_DATE
, OUTSTANDING_AMOUNT_SOB
, OUTSTANDING_AMOUNT_USD
, COMPANY_NAME
, CPARTY_NAME
, DEAL_SUBTYPE_NAME
, DEAL_TYPE_NAME
, PRODUCT_TYPE_DESC
FROM APPS.QRM_DISC_ANALYSIS_V;
APPS
FND_GLOBAL
- show dependent code
QRM_CURRENT_DEALS_V
QRM_DEALS_ANALYSES
QRM_DEAL_CALCULATIONS
QRM_TB_CALCULATIONS
XTR_DEAL_SUBTYPES
XTR_DEAL_TYPES
XTR_PARTY_INFO
XTR_PRODUCT_TYPES
APPS.QRM_DISC_ANALYSIS_V is not referenced by any database object
|
|
|
|