Search Results sob_currency_code




Overview
Explore in AI Chat

Overview

XTR_AP_OPEN_TRX_V is a Treasury (XTR) module view owned by the APPS schema. It is documented in Oracle E-Business Suite 12.2.2 as a supporting object for the Hedge Positions form, where it supplies the list of open Accounts Payable transactions that may be designated against a hedge relationship. The view presents a consolidated, user-readable projection of open invoices, their payment currency and set of books currency, vendor and operating unit context, and the various discounted amounts and dates relevant to cash flow exposure.

The view is a UNION ALL of two branches. The first branch selects directly from XTR_AP_OPEN_APLD_TRX_V, the Treasury view that holds open and applied AP transaction data. The second branch derives additional open transactions from AP_INVOICES_ALL, joining to payment schedules, vendors, vendor sites, operating units, and currency conversion logic to compute amounts in the payment currency. Because both branches expose the same column list, the view behaves as a single flattened reporting interface over several underlying AP and Treasury objects. For a user searching on sob_currency_code, this view is significant: SOB_CURRENCY_CODE is the set of books (ledger) currency of the transaction, populated in the first branch and mapped in the second branch to XPV.SET_OF_BOOKS_CURRENCY, enabling hedge exposure to be reported in both transaction and ledger currency.

Underlying Base Objects

The documented base objects referenced by the view are AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL (accessed via synonyms), AP_LOOKUP_CODES, FND_GLOBAL, FND_MESSAGE, GL_CURRENCY_API, GL_LEDGER_LE_V, HR_OPERATING_UNITS, PO_VENDORS, PO_VENDOR_SITES_ALL, XTR_AP_OPEN_APLD_TRX_V, XTR_PARTIES_V, and XTR_USER_ACCESS. The first UNION ALL branch is defined entirely over XTR_AP_OPEN_APLD_TRX_V. The second branch selects from AP_INVOICES_ALL (aliased AIA), joining AP_INVOICE_DISTRIBUTIONS_ALL (AID) for distribution amounts, PO_VENDORS (PO) and PO_VENDOR_SITES_ALL (PVS) for vendor and site names, HR_OPERATING_UNITS (HOU) for the operating unit name, XTR_PARTIES_V (XPV) for party code and set of books currency, and lookup views (ALC, ALK) for source and invoice type display values. GL_CURRENCY_API.CONVERT_AMOUNT performs currency conversion where the invoice currency differs from the payment currency, and FND_MESSAGE.GET_STRING supplies the translated source labels. GL_LEDGER_LE_V and FND_GLOBAL are referenced to resolve ledger and session context, and XTR_USER_ACCESS filters rows to the Treasury responsibility's accessible data.

Key Columns

Common Use Cases and Queries

The primary use case is the Hedge Positions form, which calls this view to display open AP transactions eligible for hedge designation. Analysts also query it directly for exposure reporting, filtering by operating unit, currency, or supplier. A typical query returning set of books currency alongside payment currency is:

  • SELECT invoice_id, trx_number, vendor_name, currency_code, sob_currency_code, amount, min_due_date FROM apps.xtr_ap_open_trx_v WHERE org_id = :p_org_id AND sob_currency_code = :p_soB ORDER BY min_due_date;
  • SELECT currency_code, sob_currency_code, SUM(amount) FROM apps.xtr_ap_open_trx_v WHERE applied_trx IS NULL GROUP BY currency_code, sob_currency_code; — to obtain total open exposure by transaction and ledger currency.
  • SELECT vendor_name, COUNT(*), SUM(amount) FROM apps.xtr_ap_open_trx_v WHERE org_id = :p_org_id GROUP BY vendor_name; — to identify supplier-level exposure concentrations.

Because SOB_CURRENCY_CODE exposes the functional currency of the transaction, it is the correct column to use when reconciling Treasury hedge positions to General Ledger balances in 12.1.1 and 12.2.2.