[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.QRM_DISC_ANALYSIS_TB_V is not referenced by any database object
|
|
|