Results for “consideration_amount”

16 results




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

Overview

XTR_A_ALL_CONTRACTS_V is a consolidated, APPS-owned reporting view within the Oracle E-Business Suite Treasury (XTR) module. Its purpose is to present a single, unified projection of treasury contract and deal data spanning multiple instrument types — foreign exchange (FX), FX options (FXO), forwards (FRA), futures (FUT), interest rate instruments (IRO, IRS), swaps (SWPTN), and treasury money market deals (TMM). Rather than querying the underlying deal tables directly, Oracle EBS reports, concurrent programs, and integration extracts reference this view so that heterogeneous contracts are exposed through a consistent set of column aliases.

The view is especially relevant to users searching on broker_amount. As documented in the view text, the column BROKER_AMOUNT is a straightforward alias of the base column D.BROKERAGE_AMOUNT. It therefore carries the brokerage (broker commission) amount associated with a given deal, expressed in the contract currency determined by the instrument type. Because the view aggregates all contract subtypes, broker_amount can be reported uniformly across FX, money market, and derivative contracts.

Underlying Base Objects

The documented ETRM 12.2.2 metadata identifies the following referenced base objects:

  • XTR_A_DEALS (synonym) — the primary source of deal header attributes, supplying most projected columns including BROKERAGE_AMOUNT.
  • XTR_A_ROLLOVER_TRANSACTIONS (synonym) — supports rollover-related deal identifiers.
  • XTR_DEALS_V (view) — a deal-level view providing supplemental contract data.
  • XTR_DEAL_STATUSES (synonym) — supplies status code/description data for the CONTR_STATUS projection.
  • XTR_DEAL_SUBTYPES (synonym) — referenced to resolve DEAL_SUBTYPE into a user-deal subtype.
  • XTR_ROLLOVER_TRANSACTIONS_V (view) — the view-side counterpart used for rollover transaction number derivation.
  • XTR_USER_ACCESS (package) — enforces user access/security filtering so that only authorized dealers and companies see their own contracts.

Additional joins in the view text reference ST.USER_DEAL_SUBTYPE, confirming a join to the deal subtype table to translate internal subtype codes into user-facing labels.

Key Columns

Common Use Cases and Queries

Typical uses include treasury broker cost analysis, counterparty exposure reports, and downstream integration extracts that require a normalized contract record.

  • Brokerage cost analysis by instrument type and counterparty.
  • Contract registers spanning FX, money market, and derivative deals.
  • Integration extracts that feed risk or accounting systems.

Sample query listing broker amounts:

  • SELECT CONTRACT_NO, CONTRACT_SUBTYPE, CURRENCY, BROKER_AMOUNT, BROKER_RATE, COUNTERPARTY FROM APPS.XTR_A_ALL_CONTRACTS_V WHERE BROKER_AMOUNT IS NOT NULL;
  • SELECT PRODUCT, SUM(BROKER_AMOUNT) TOTAL_BROKERAGE FROM APPS.XTR_A_ALL_CONTRACTS_V GROUP BY PRODUCT;

Because access is filtered through XTR_USER_ACCESS, results reflect the responsibilities and dealer assignments of the querying user.