Search Results xtr_ar_open_apld_trx_v




Overview
Explore in AI Chat

Overview

The XTR_AR_OPEN_APLD_TRX_V view is a Treasury (XTR) module reporting object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It consolidates open (unapplied) Accounts Receivable transactions with their associated payment schedules and party information, presenting a single denormalized record per open transaction/payment-schedule combination. The view joins Receivables transaction tables with Treasury party data (XTR_PARTIES_V) and General Ledger legal-entity/ledger hierarchy information, producing a reconciliation-ready dataset used in treasury integration and financial reporting.

Its design supports Treasury's need to see outstanding customer obligations alongside the legal entity and ledger context required for cash management and exposure reporting. It is not a transactional table; it exposes no DML and is intended for read-only query, extraction, and integration into Treasury dashboards and third-party banking or risk systems.

Underlying Base Objects

The view is defined over the following documented base objects:

Key Columns

  • CUSTOMER_TRX_ID / PAYMENT_SCHEDULE_ID — Primary identifiers for the transaction and its payment schedule.
  • TRX_NUMBER, TRX_DATE — Invoice/transaction number and date.
  • CUSTOMER_ID, CUSTOMER_NAME — Customer account identifier and party name.
  • COMPANY_CODE — Treasury party code, aligned to legal entity.
  • ORG_ID, ORG_NAME — Operating unit context.
  • CURRENCY_CODE, SOB_CURRENCY_CODE — Transaction currency and the primary set-of-books currency for conversion context.
  • AMOUNT — NVL(AMOUNT_DUE_REMAINING, 0), the remaining open balance.
  • MIN_DUE_DATE — Earliest due date for the schedule.
  • APPLIED_TRX — Constant 'Y' flag marking the row as an open/applied transaction record used as a filter indicator.

Common Use Cases and Queries

Typical scenarios include producing an aged open receivables report by legal entity, feeding treasury exposure calculations, and reconciling AR balances to Treasury party codes.

SELECT trx_number, customer_name, company_code,
       currency_code, sob_currency_code, amount, min_due_date
FROM   xtr_ar_open_apld_trx_v
WHERE  org_id = :p_org_id
ORDER BY min_due_date;

To aggregate open exposure per Treasury party and currency:

SELECT company_code, currency_code, SUM(amount) total_open
FROM   xtr_ar_open_apld_trx_v
GROUP BY company_code, currency_code;

Because the view embeds Treasury user access and legal-entity logic, queries executed under an APPS or Treasury responsibility automatically reflect the caller's data security, making it suitable for direct use in concurrent reports, OAF pages, and integration extracts without additional filtering.