[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | QRM_DISC_ANALYSIS_TB_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  QRM.QRM_DISC_ANALYSIS_TB_V
|
| Subobject Name: | |
| Status: | VALID |
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.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ANALYSIS_NAME | VARCHAR2 | (20) | Yes | 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) | Yes | Refer to base table or view |
| DEAL_TYPE | VARCHAR2 | (7) | Yes | 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 | 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_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) | 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
, TB_START_DATE
, TB_END_DATE
, DEAL_NO
, TRANSACTION_NO
, MARKET_DATA_SET
, CALL_OR_PUT
, OPTION_STYLE
, ISSUER_CODE
, COMPANY_CODE
, DEALER_CODE
, CLIENT_CODE
, CPARTY_CODE
, PORTFOLIO_CODE
, LINK_CODE
, PRICING_MODEL
, DEAL_CCY
, BUY_CCY
, SELL_CCY
, FOREIGN_CCY
, DOMESTIC_CCY
, BASE_CCY
, CONTRA_CCY
, SENSITIVITY_CCY
, PREMIUM_CCY
, BUY_AMOUNT
, SELL_AMOUNT
, FOREIGN_AMOUNT
, DOMESTIC_AMOUNT
, BASE_CCY_AMOUNT
, CONTRA_CCY_AMOUNT
, START_AMOUNT
, FACE_VALUE
, INTEREST
, ACCUM_INTEREST_BF
, ACCUM_INT_ACTION
, ACCRUED_INTEREST_PRICE
, INTEREST_SETTLED
, DEAL_DATE
, END_DATE
, DEAL_SUBTYPE
, DEAL_TYPE
, DISCOUNT_YIELD
, EXPIRATION_DATE
, MATURITY_DATE
, NO_OF_DAYS
, MARKET_TYPE
, INSTR_TYPE
, MM_FX_INSTR_TYPE
, VALUE_DATE
, SETTLE_DATE
, PREMIUM_AMOUNT
, PRODUCT_TYPE
, START_DATE
, PHY_START_DATE
, KNOCK_TYPE
, KNOCK_LEVEL
, KNOCK_EXECUTE_DATE
, INITIAL_BASIS
, INT_SWAP_REF
, INT_REF
, BOND_ISSUE_CODE
, SECURITY_ID
, REF_SPOT_RATE
, COUPON_ACTION
, MARGIN
, TRANSACTION_RATE
, INTEREST_FREQUENCY
, COUPON_FREQUENCY
, DAY_COUNT_BASIS
, QUANTITY_REMAINING
, QUANTITY_REMAINING_USD
, QUANTITY_REMAINING_SOB
, ROUNDING_TYPE
, DAY_COUNT_TYPE
, PREPAID_INTEREST
, 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_THETA
, POS_THETA_USD
, POS_THETA_SOB
, POS_VEGA_USD
, POS_VEGA_SOB
, YIELD_TO_MATURITY
, LAST_MD_CALC_DATE
, TRANSACTION_PRICE
, TRANSACTION_PRICE_USD
, TRANSACTION_PRICE_SOB
, REVALUATION_PRICE
, REVALUATION_PRICE_USD
, REVALUATION_PRICE_SOB
, INTEREST_BASIS
, OUTSTANDING_AMOUNT
, OUTSTANDING_AMOUNT_USD
, OUTSTANDING_AMOUNT_SOB
, COUPON_RATE
, NEXT_COUPON_DATE
, AMT_QTY_OUT
, AMT_QTY_OUT_USD
, AMT_QTY_OUT_SOB
, COMPANY_NAME
, CPARTY_NAME
, DEAL_SUBTYPE_NAME
, DEAL_TYPE_NAME
, PRODUCT_TYPE_DESC
FROM APPS.QRM_DISC_ANALYSIS_TB_V;
APPS
FND_GLOBAL
- show dependent code
QRM_CURRENT_DEALS_V
QRM_DEALS_ANALYSES
QRM_DEAL_CALCULATIONS
QRM_SAVED_ANALYSES_COL
QRM_TB_CALCULATIONS
XTR_DEAL_SUBTYPES
XTR_DEAL_TYPES
XTR_PARTY_INFO
XTR_PRODUCT_TYPES
APPS.QRM_DISC_ANALYSIS_TB_V is not referenced by any database object
|
|
|
|