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

VIEW: APPS.QRM_CURRENT_DEALS_V

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

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.


[View Source]

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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
,      INTEREST_SETTLED
,      DEAL_DATE
,      END_DATE
,      GAP_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
,      COUPON_RATE
,      MARGIN
,      TRANSACTION_RATE
,      INTEREST_FREQUENCY
,      COUPON_FREQUENCY
,      NEXT_COUPON_DATE
,      DAY_COUNT_BASIS
,      QUANTITY_REMAINING
,      QUANTITY_REMAINING_USD
,      QUANTITY_REMAINING_SOB
,      ROUNDING_TYPE
,      DAY_COUNT_TYPE
,      PREPAID_INTEREST
FROM APPS.QRM_CURRENT_DEALS_V;

Dependencies

[top of page]

APPS.QRM_CURRENT_DEALS_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymXTR_BOND_ISSUES
SynonymXTR_BUY_SELL_COMBINATIONS
SynonymXTR_COMPANY_AUTHORITIES
SynonymXTR_DEALER_CODES
SynonymXTR_DEALS
SynonymXTR_INTERGROUP_TRANSFERS
SynonymXTR_ROLLOVER_TRANSACTIONS
ViewXTR_TY_SUB_PRD_COMBIN_V
APPS.QRM_CURRENT_DEALS_V is referenced by following:

SchemaAPPS
ViewQRM_ANALYSIS_DEALS_V
ViewQRM_ANALYSIS_DISC_V
ViewQRM_DISC_ANALYSIS_TB_V
ViewQRM_DISC_ANALYSIS_V
Package BodyQRM_PA_AGGREGATION_P - show dependent code
Package BodyQRM_PA_CALCULATION_P - show dependent code