Results for “ap_terms_v”

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

Overview

AP_TERMS_V is a Payables (AP) view owned by the APPS schema in Oracle E-Business Suite. The ETRM metadata describes it as a Release 10SC-era object, and it remains valid in the 12.1.1 and 12.2.2 releases. The view is a thin projection over the AP_TERMS base object and provides a stable, read-only interface for payment terms definitions used throughout Payables, Purchasing, and Receivables reporting. Because it exposes all standard payment term columns—including DUE_CUTOFF_DAY, the column most commonly referenced when searching for this view—AP_TERMS_V serves as a convenient reporting surface for developers and integrators who need to join payment terms to invoices, suppliers, or purchasing documents without directly querying the base table.

Underlying Base Objects

The documented metadata lists a single referenced base object: the AP_TERMS synonym (which resolves to the AP_TERMS table owned by AP). The view text confirms this directly:

• FROM AP_TERMS AT — a single-table SELECT with no joins, unions, or aggregations.
• Every view column is a direct 1:1 alias of a corresponding AP_TERMS column, including AT.ROW_ID, which maps to the base table's ROWID.

Because the view performs no filtering or transformation, row counts and values are identical to the underlying AP_TERMS table. This makes it a pure pass-through view, useful for controlled access and backward compatibility rather than for business logic.

Key Columns

• TERM_ID — Primary identifier for the payment term; primary key and the join key to AP_INVOICE_PAYMENTS, PO_HEADERS, and similar tables.
• NAME — The user-visible payment term name (for example, "Net 30" or "2/10 Net 30").
• DESCRIPTION — Free-form descriptive text for the term.
• DUE_CUTOFF_DAY — Identifies the day of the month on which the due date is cut off for the term. This column is significant for terms that compute due dates relative to month boundaries rather than directly from the invoice date.
• TYPE — Classifies the term's calculation method (for example, discount-based, installment, or fixed-day terms).
• ENABLED_FLAG — Indicates whether the term is active and selectable.
• START_DATE_ACTIVE / END_DATE_ACTIVE — Define the effective date range during which the term is valid.
• RANK — Ordering attribute used when multiple terms are evaluated.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard EBS descriptive flexfield (DFF) columns, enabling site-specific term attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns, populated by the Forms audit framework.
• ROW_ID — Exposes the underlying AP_TERMS row identifier for applications that require row-level addressing.

Common Use Cases and Queries

The view is typically used in reporting and integration SQL to resolve a term identifier into its name, type, and cutoff behavior. Common scenarios include listing all enabled terms for a supplier setup report, joining terms to invoices for aging analysis, and investigating how due dates are calculated when DUE_CUTOFF_DAY is populated.

• List enabled terms: SELECT term_id, name, type, due_cutoff_day FROM ap_terms_v WHERE enabled_flag = 'Y' ORDER BY name;
• Find terms using a due cutoff day: SELECT term_id, name, due_cutoff_day, type FROM ap_terms_v WHERE due_cutoff_day IS NOT NULL;
• Effective-dated term lookup: SELECT name, start_date_active, end_date_active FROM ap_terms_v WHERE TRUNC(SYSDATE) BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE);
• Join to invoices: SELECT ai.invoice_num, atv.name term_name, atv.due_cutoff_day FROM ap_invoices_all ai, ap_terms_v atv WHERE ai.terms_id = atv.term_id;

Because the view carries the APPS synonym and ROW_ID, it can be queried through standard EBS reporting tools (BI Publisher, Oracle Reports, Discoverer) or directly from PL/SQL and external integrations, provided the APPS schema or a synonym grant is in place.