Search Results applied_trx




Overview
Explore in AI Chat

Overview

APPS.XTR_AR_OPEN_APLD_TRX_V is a read-only view registered in the Applications schema of Oracle E-Business Suite 12.1.1 and 12.2.2, with FND Design Data identifier XTR.XTR_AR_OPEN_APLD_TRX_V. It belongs to the Oracle Treasury (XTR) product family and consolidates open and applied Accounts Receivable transactions for consumption by Treasury cash-flow and receivable-matching functionality. The object carries an Oracle Internal Use Only designation; Oracle Corporation does not support direct customer access to this data except through standard Oracle Applications programs.

The view returns one row per payment schedule line, joining receivables transaction data with batch source, transaction type, customer, operating unit, and ledger information. The presence of the SOB_CURRENCY_CODE column—the item identified in the triggering search—allows reporting logic to compare the transaction currency (CURRENCY_CODE) against the ledger or set of books currency, which is essential for functional-currency conversion and exposure reporting in Treasury. The view serves as an intermediate layer: it references base AR tables directly and is itself consumed by the higher-level view XTR_AR_OPEN_TRX_V.

Underlying Base Objects

The documented dependency list identifies the following objects as sources for the view definition:

The view is referenced downstream by APPS.XTR_AR_OPEN_TRX_V, which aggregates the schedule-level rows into the open-transaction display used by Treasury dashboards.

Key Columns

The projection begins with CUSTOMER_TRX_ID, PAYMENT_SCHEDULE_ID, and BATCH_SOURCE_ID, which form the core transaction identity. Descriptive attributes follow: SOURCE_NAME, CUST_TRX_TYPE_ID, TRX_TYPE_NAME, ORG_ID, ORG_NAME, CUSTOMER_ID, CUSTOMER_NAME, and COMPANY_CODE. The COMPANY_CODE column reflects the Treasury company or legal entity associated with the receivable.

Financial attributes include TRX_DATE, TRX_NUMBER, CURRENCY_CODE, SOB_CURRENCY_CODE, AMOUNT, and MIN_DUE_DATE. CURRENCY_CODE is the transaction currency of the receivable; SOB_CURRENCY_CODE is the currency of the set of books (ledger) to which the operating unit belongs. When the two differ, the transaction is a foreign-currency receivable, and the AMOUNT value is expressed in the transaction currency, requiring conversion for ledger-level reporting. The APPLIED_TRX column is a single-character flag indicating whether the schedule line has been applied against a receipt.

Common Use Cases and Queries

Typical use is Treasury open-receivable reporting, cross-currency exposure analysis, and aging of unapplied transactions. Because the object is unsupported for direct access, queries should be limited to diagnostics and support scenarios.

A representative query listing foreign-currency open items is:

  • SELECT trx_number, customer_name, currency_code, sob_currency_code, amount, min_due_date FROM apps.xtr_ar_open_apld_trx_v WHERE currency_code <> sob_currency_code AND org_id = :p_org_id ORDER BY min_due_date;
  • SELECT org_name, sob_currency_code, SUM(amount) FROM apps.xtr_ar_open_apld_trx_v GROUP BY org_name, sob_currency_code;
  • SELECT trx_number, applied_trx, min_due_date FROM apps.xtr_ar_open_apld_trx_v WHERE applied_trx = 'N' AND customer_id = :p_customer_id;

Filtering by ORG_ID is advisable, since XTR_USER_ACCESS enforces organization-level security within the view's underlying logic.