Search Results xtr_deal_date_amounts_v




Overview
Explore in AI Chat

Overview

XTR_DEAL_DATE_AMOUNTS_V is a Treasury (XTR) module database view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes deal date and amount information held in the Treasury deals foundation tables, presenting one row per deal date/amount combination across treasury deal types, batches, and amount categories. The view is not a base table; it is a read-only projection defined over XTR_DEAL_DATE_AMOUNTS (referenced through a synonym) that adds a security predicate restricting returned data to the companies a user is authorized to access.

Its principal operational role is to provide a secured, denormalized reporting surface for Treasury deal amounts. Applications and custom reports can query the view without embedding company-authority logic themselves, because the view applies the restriction through a subquery against XTR_COMPANY_AUTHORITIES. It is therefore commonly used for deal amount enquiries, settlement and reconciliation reporting, exposure analysis, accrual reporting, and interfaces that extract treasury deal amounts for downstream consumption.

Underlying Base Objects

The documented base objects for this view are:

  • XTR_DEAL_DATE_AMOUNTS (SYNONYM) — the primary source table. All columns listed in the view text are selected from this table using the alias XDDA.
  • XTR_COMPANY_AUTHORITIES (SYNONYM) — referenced in the WHERE clause to constrain COMPANY_CODE to the party codes the current user is authorized to view.
  • XTR_USER_ACCESS (PACKAGE) — the documented package associated with user/company access resolution within Treasury.

The defining query selects the full column list from XTR_DEAL_DATE_AMOUNTS and filters with: WHERE XDDA.COMPANY_CODE IN (SELECT XCA.PARTY_CODE ...), which is the company security filter. Because the view is defined over a synonym, it resolves to the APPS-owned table in the standard EBS single-schema deployment. No joins to other master tables are present in the view text; descriptive attributes such as currency, deal type, and status codes are returned as stored on the deal date amount record.

Key Columns

The view exposes a broad set of deal, date, amount, settlement, and audit attributes. Notable columns include:

Common Use Cases and Queries

Typical scenarios include listing all amounts for a deal, filtering by amount type or date type for accrual and interest reporting, reconciling settlement amounts, and extracting authorized data for interfaces. Because the view already enforces company security, it is the preferred access path for custom reports over XTR_DEAL_DATE_AMOUNTS.

Example queries:

  • All amounts for a specific deal:
    SELECT deal_number, amount_type, date_type, amount_date, amount, currency FROM xtr_deal_date_amounts_v WHERE deal_number = :deal;
  • Accrual rows within a period:
    SELECT deal_number, accrual_from, accrual_to, amount, hce_amount FROM xtr_deal_date_amounts_v WHERE amount_type = :accrual AND amount_date BETWEEN :from AND :to;
  • Unsettled or pending settlements:
    SELECT deal_number, settlement_number, settle, settlement_actioned, actual_settlement_date FROM xtr_deal_date_amounts_v WHERE settle = 'N';
  • Balances by company and currency:
    SELECT company_code, currency, SUM(hce_amount) FROM xtr_deal_date_amounts_v WHERE amount_type = :principal GROUP BY company_code, currency;

As with all APPS views, consumers should apply standard EBS access controls and confirm that the view remains VALID after patching, since its definition and the underlying company authority subquery must align with current Treasury security configuration.