Results for “discount_date”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• AR_PAYMENT_SCHEDULES (PS) — supplies the payment schedule identifier, transaction identifier and number, remaining amount due, currency, customer, and site-use identifiers, along with transaction date and class.
• RA_TERMS (T) — supplies term header attributes, including DUE_CUTOFF_DAY, CALC_DISCOUNT_ON_LINES_FLAG, and PARTIAL_DISCOUNT_FLAG.
• RA_TERMS_LINES_DISCOUNTS (TLD) — supplies the discount percent, discount days, discount date, discount months forward, and discount day of month used in the date derivation.

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

• PAYMENT_SCHEDULE_ID / CUSTOMER_TRX_ID / TRX_NUMBER — the schedule and transaction identifiers and the user-facing transaction number.
• DISCOUNT_PERCENT — the discount rate taken directly from the terms line discount record.
• DISCOUNT_DATE — a TRUNC'd date derived from DISCOUNT_DAYS when populated, otherwise from DISCOUNT_DATE or a month-forward calculation using DISCOUNT_MONTHS_FORWARD, DISCOUNT_DAY_OF_MONTH, and the terms' DUE_CUTOFF_DAY.
• CALC_DISCOUNT_ON_LINES_FLAG — indicates whether discounts are calculated at line level.
• PARTIAL_DISCOUNT_FLAG — indicates whether partial discounts are permitted for the term, which is central to the user's search term.
• AMOUNT_DUE_REMAINING, INVOICE_CURRENCY_CODE, CUSTOMER_ID, CUSTOMER_SITE_USE_ID — the remaining balance and party/currency context of the installment.

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.