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
- CONTRACT_NO, ROLLOVER_TRANSACTION_NO — deal number and, for ONC deals, the associated rollover transaction.
- COMPANY, COUNTERPARTY, CLIENT — organizational parties on the contract.
- ACCEPTOR, ENDORSER, DRAWER — party roles used in money market/instrument instruments.
- CONTRACT_SUBTYPE, USER_DEAL_SUBTYPE, PRODUCT, PORTFOLIO — classification attributes (PRODUCT and PORTFOLIO default to 'NOT APPLIC' when null).
- CURRENCY, CURRENCY_SELL — CURRENCY is decoded so that FX/FXO use CURRENCY_BUY, otherwise the base currency column.
- CONTRACT_DEALT_ON, COMMENCE_DATE, MATURITY_DATE, SETTLEMENT_DATE, PREMIUM_DATE, OPTION_EXPIRY — the deal date set, with COMMENCE_DATE decoded per instrument.
- AMOUNT, SELL_AMOUNT, CONSIDERATION_AMOUNT, SETTLEMENT_AMOUNT, PREMIUM_AMOUNT — principal and cash amounts, where AMOUNT is decoded across deal types.
- BROKER_AMOUNT — the documented alias for D.BROKERAGE_AMOUNT, the broker commission value.
- TAX_AMOUNT, CONTRACT_RATE, COUPON_RATE, BROKER_RATE, TAX_RATE, SETTLEMENT_RATE — tax and rate details; BROKER_RATE mirrors D.BROKERAGE_RATE.
- UPDATED_ON_DATE, UPDATED_BY_USER — audit columns (UPDATED_ON defaults to 01/01/1900).
- COMPANY_DEALER, COMPANY_SETTLEMENT_ACCT, COUNTERPARTY_ACCT_REF, PREMIUM_ACCT, FX_BUY_SETTLEMENT_ACCT, FX_SELL_SETTLEMENT_ACCT, SETTLEMENT_ACCT — dealer and account references.
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.
-
View: XTR_A_ALL_CONTRACTS_V 12.2.2
APPS.XTR_A_ALL_CONTRACTS_V·↳ XTR_A_DEALS·↳ XTR_A_ROLLOVER_TRANSACTIONS·↳ XTR_DEALS_V·Explore XTR module →
-
This view contains full deal information for all instruments with the exception of exposure transactions. Its main purpose is to inquire on deal information across all deal types.
APPS.XTR_REVIEW_ALL_CONTRACTS_V·↳ XTR_BANK_ACCOUNTS·↳ XTR_DEALS_V·↳ XTR_DEAL_STATUSES·Explore XTR module →
-
View: XTR_A_ALL_CONTRACTS_V 12.1.1
APPS.XTR_A_ALL_CONTRACTS_V·↳ XTR_A_DEALS·↳ XTR_A_ROLLOVER_TRANSACTIONS·↳ XTR_DEALS_V·Explore XTR module →
-
This view contains full deal information for all instruments with the exception of exposure transactions. Its main purpose is to inquire on deal information across all deal types.
APPS.XTR_REVIEW_ALL_CONTRACTS_V·↳ XTR_BANK_ACCOUNTS·↳ XTR_DEALS_V·↳ XTR_DEAL_STATUSES·Explore XTR module →
-
eTRM - XTR Tables and Views 12.1.1
Created on 29-OCT-96
-
eTRM - XTR Tables and Views 12.2.2
Created on 29-OCT-96