Search Results ar_trx_discounts_v




Overview
Explore in AI Chat

Overview

AR_TRX_DISCOUNTS_V is a Receivables (AR) view owned by the APPS schema that exposes the early-payment discount information attached to a transaction's payment schedule. Its embedded purpose comment states explicitly that it "is used to get discount information for LOV in applications window," identifying it as a supporting object for Oracle Forms list-of-values and related inquiry logic rather than a core transaction-processing entity. The view joins payment schedule rows to the terms and terms-line-discounts tables so that users can see, for a given installment, the applicable discount percent, the computed discount date, and the flags that govern how the discount behaves.

The ETRM metadata designates AR_TRX_DISCOUNTS_V as Release 11.5-only documentation, and the object is recorded as VALID under the APPS schema in both 12.1.1 and 12.2.2. Its presence in later releases reflects a narrow purpose: it is a residual convenience view from the 11.5 windowed LOV design. It remains available for ad-hoc queries and diagnostics, but customers should treat it as a documented legacy artifact rather than a supported extension point.

Underlying Base Objects

The view text selects from three base objects, all catalogued as synonyms in the documented metadata:

Joins are enforced on T.TERM_ID = TLD.TERM_ID and PS.TERM_ID = T.TERM_ID, with the additional correlation PS.TERMS_SEQUENCE_NUMBER = TLD.SEQUENCE_NUM. The view also filters out schedules whose class is 'PMT' or 'GUAR', restricting output to invoice-type installments.

Key Columns

Common Use Cases and Queries

Typical usage is inquiry-driven: identifying discount-eligible installments for a transaction, validating the computed discount date against a term setup, or surfacing the partial discount flag during troubleshooting. A representative query filtering on the search term is:

SELECT trx_number, discount_percent, discount_date, partial_discount_flag, amount_due_remaining FROM apps.ar_trx_discounts_v WHERE partial_discount_flag = 'Y' AND customer_trx_id = :p_trx_id;

A second pattern retrieves all discount terms for a transaction's schedules:

SELECT trx_number, payment_schedule_id, discount_percent, discount_date, calc_discount_on_lines_flag FROM apps.ar_trx_discounts_v WHERE trx_number = :p_trx_number ORDER BY discount_date;

Because the view is documented as 11.5-only, reports should generally be built against RA_TERMS and RA_TERMS_LINES_DISCOUNTS directly when a supported, forward-compatible definition is required.