Search Results invoice_to_site_location




Overview
Explore in AI Chat

Overview

APPS.OEFV_ORDER_AGREEMENTS is a reporting view in the Oracle Order Management (ONT) application, registered under FND Design Data as ONT.OEFV_ORDER_AGREEMENTS. It presents pricing and service agreement header information maintained in the Order Management agreements schema, consolidated with related customer, site, currency, and pricing-list attributes for read-only consumption. The view is classified in Oracle E-Business Suite documentation as Oracle Internal Use Only; Oracle Corporation does not support direct access to application data through this object except from standard Oracle Applications programs. Its status in the APPS schema is documented as VALID, and the view type is described as internal.

The view is most commonly encountered by technical consultants and report developers who need to expose agreement-level attributes — such as agreement number, name, start and end dates, invoicing rules, accounting rules, payment terms, price lists, and invoice-to site details — in custom reports, extracts, and integration feeds. Because the object is not a supported public API, its use should be treated as a read-only convenience over the underlying transaction tables and validated against each specific 12.1.1 or 12.2.2 instance before being embedded in production code.

Underlying Base Objects

The ETRM metadata documents that OEFV_ORDER_AGREEMENTS is defined over the following base objects, referenced through APPS synonyms:

The view therefore acts as a join hub, pulling agreement records from Order Management and enriching them with customer, site, terms, rule, and pricing-list descriptions.

Key Columns

Common Use Cases and Queries

A frequent requirement is identifying agreements whose start date was altered after creation. The START_DATE_CHANGED column supports this directly:

SELECT agreement_number, agreement_name, start_date_changed, end_date, signature_date
FROM apps.oefv_order_agreements
WHERE start_date_changed IS NOT NULL
ORDER BY start_date_changed DESC;

Another common pattern is producing an agreement extract with terms, pricing list, and invoice-to address for reconciliation or audit:

SELECT agreement_number, agreement_name, payment_terms_name, price_list_name,
       invoice_to_site_city, invoice_to_site_country, agreement_revision
FROM apps.oefv_order_agreements
WHERE end_date >= TRUNC(SYSDATE);

Because the view is documented as internal and unsupported for direct access, developers should restrict queries to read-only reporting, avoid placing business logic on it, and confirm column availability in each target instance (12.1.1 versus 12.2.2) before deployment.