Results for “int_swap_ref”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

QRM_CURRENT_DEALS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the QRM (Risk Management) product family within the ETRM (Enterprise Treasury and Risk Management) suite. Its documented purpose is to expose the set of current Treasury deals used by Risk Analysis. In practice, the view acts as a normalized, risk-oriented projection of the deal data held in the XTR (Treasury) tables, presenting a fixed, uniform column layout that the risk analytics engine can consume regardless of the underlying instrument type.

The view is defined with an explicit SELECT list rather than a wildcard, and many of its columns are populated with literal constants, DECODE expressions, or TO_NUMBER(NULL) placeholders. This design reflects its role as a compatibility or interface layer: it conforms heterogeneous deal records to a single canonical record shape, filling columns that are not meaningful for Treasury deals with NULL or static indicator values. Because the object is a view, it holds no data of its own and always reflects the current state of the underlying Treasury tables at query time.

Underlying Base Objects

The documented metadata for ETRM 12.2.2 identifies the following referenced objects: FND_GLOBAL (package), the synonyms XTR_BOND_ISSUES, XTR_BUY_SELL_COMBINATIONS, XTR_COMPANY_AUTHORITIES, XTR_DEALER_CODES, XTR_DEALS, XTR_INTERGROUP_TRANSFERS, and XTR_ROLLOVER_TRANSACTIONS, together with the view XTR_TY_SUB_PRD_COMBIN_V.

The view text itself draws its principal deal attributes from XTR_DEALS (aliased D), supplying DEAL_NO, CURRENCY, DEAL_TYPE, DEAL_SUBTYPE, EXPIRY_DATE, VALUE_DATE, PREMIUM_AMOUNT, MARKET_DATA_SET, CAP_OR_FLOOR, FIXED_OR_FLOATING_RATE, INT_SWAP_REF, BOND_ISSUE, SECURITY_ID, and COUPON_ACTION. Transaction-level and position-level attributes are taken from XTR_ROLLOVER_TRANSACTIONS (aliased RT), including TRANSACTION_NUMBER, COMPANY_CODE, DEALER_CODE, CLIENT_CODE, CPARTY_CODE, PORTFOLIO_CODE, DEAL_LINKING_CODE, PRINCIPAL_ADJUST, BALANCE_OUT, INTEREST, ACCUM_INTEREST_BF, ACCUM_INT_ACTION, DEAL_DATE, MATURITY_DATE, SETTLE_DATE, START_DATE, NO_OF_DAYS, DEAL_SUBTYPE, and PRODUCT_TYPE. The synonyms for XTR_BOND_ISSUES, XTR_BUY_SELL_COMBINATIONS, XTR_COMPANY_AUTHORITIES, XTR_DEALER_CODES, XTR_INTERGROUP_TRANSFERS, and the XTR_TY_SUB_PRD_COMBIN_V view support the join and lookup logic, while FND_GLOBAL supplies session context such as the current user and responsibility used for access filtering. The APPS synonym APPS.QRM_CURRENT_DEALS_V is the schema-qualified entry point exposed to callers.

Key Columns

• DEAL_NO – Deal identifier from XTR_DEALS, the primary business key of the record.
• TRANSACTION_NO – Rollover transaction number, defaulted to 1 via NVL when absent.
• DEAL_CCY – The deal currency, mapped directly from D.CURRENCY. Because the user searched on "deal_ccy", this is the column of principal interest; it is also reused as SENSITIVITY_CCY, while BUY_CCY, SELL_CCY, FOREIGN_CCY, DOMESTIC_CCY, BASE_CCY, CONTRA_CCY, and PREMIUM_CCY are all set to NULL.
• COMPANY_CODE, DEALER_CODE, CLIENT_CODE, CPARTY_CODE, PORTFOLIO_CODE, LINK_CODE – Organizational and counterparty attribution carried from XTR_ROLLOVER_TRANSACTIONS.
• DEAL_TYPE, DEAL_SUBTYPE, PRODUCT_TYPE, MM_FX_INSTR_TYPE – Instrument classification; MM_FX_INSTR_TYPE is derived by DECODE to 'F' for FUND and 'I' for INVEST.
• START_AMOUNT, FACE_VALUE, INTEREST, ACCUM_INTEREST_BF, ACCUM_INT_ACTION – Position and accrual measures from the rollover transaction.
• DEAL_DATE, START_DATE, VALUE_DATE, SETTLE_DATE, MATURITY_DATE, END_DATE, EXPIRATION_DATE – Date attributes, each wrapped in TRUNC to strip time components.
• MARKET_TYPE ('M'), INSTR_TYPE ('P'), DISCOUNT_YIELD ('N') – Static indicators that signal to the risk engine that the record originates from the money market / Treasury domain.

Common Use Cases and Queries

The view is typically queried by risk analysis and treasury reporting processes that need a currency-tagged, date-truncated snapshot of current deals. A frequent pattern is filtering or grouping by currency, which is precisely the DEAL_CCY column:

• List all current deals in a given currency:

  SELECT deal_no, transaction_no, company_code, deal_ccy,
         deal_type, deal_subtype, start_amount, face_value,
         deal_date, maturity_date
  FROM   apps.qrm_current_deals_v
  WHERE  deal_ccy = 'USD';

• Aggregate currency exposure by portfolio:

  SELECT deal_ccy, portfolio_code, SUM(face_value) total_face
  FROM   apps.qrm_current_deals_v
  GROUP  BY deal_ccy, portfolio_code;

• Identify deals maturing within a window relative to the value date:

  SELECT deal_no, deal_ccy, value_date, maturity_date
  FROM   apps.qrm_current_deals_v
  WHERE  maturity_date BETWEEN value_date AND value_date + 90;

• Distinguish fund versus invest instruments using the derived indicator:

  SELECT deal_no, deal_ccy, mm_fx_instr_type, product_type
  FROM   apps.qrm_current_deals_v
  WHERE  mm_fx_instr_type = 'I';

Because the column list is fixed and many fields are NULL placeholders, the view is best used for read-only risk and reporting extracts rather than for transactional updates. All access should be performed through the APPS synonym, and results depend on the current contents of XTR_DEALS and XTR_ROLLOVER_TRANSACTIONS at execution time.