Results for “oefv_price_lists”

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

Overview

The view OEFV_PRICE_LISTS belongs to the Oracle Order Entry (OE) module and provides a denormalized, read-only representation of price list header data. It is a flexfield-enabled ("_DF") view, retrofitted for the E-Business Suite 12.1.1 and 12.2.2 releases, and is identified in ETRM documentation under the title View: OEFV_PRICE_LISTS. Its principal role is to expose descriptive attributes of a price list — name, description, currency-related freight terms, rounding rules, active dates, and associated secondary price list, ship method, and payment terms — in a single joined result set that reporting tools, concurrent programs, and integration interfaces can consume without manually resolving foreign keys.

The view is defined WITH READ ONLY, which means it cannot be used as the target of DML; it is purely a query surface. Its inclusion of the _DF flexfield discriminator column signals that it participates in the Oracle Applications descriptive flexfield framework, supporting downstream attribute rendering.

Underlying Base Objects

Although the ETRM metadata records "Referenced base objects: none documented," the view definition itself reveals the following underlying tables:

• SO_PRICE_LISTS — aliased twice, once as PRICELIST (the primary record) and once as PRICELIST2 (the self-join resolving the secondary price list name).
• ORG_FREIGHT — supply the ship method description via SHIP_METHOD_CODE.
• RA_TERMS — supplies the payment terms name via TERMS_ID.
• SO_LOOKUPS — supplies the freight terms meaning, restricted to LOOKUP_TYPE = 'FREIGHT_TERMS'.

The joins to PRICELIST2, ORG_FREIGHT, RA_TERMS, and SO_LOOKUPS are all outer joins ((+)), so the view preserves the primary price list row even when secondary, freight, terms, or lookup data are absent. The ETRM entry notes this view is "Not implemented in this database," meaning the metadata reflects the shipped definition rather than an active object in the queried instance.

Key Columns

• PRICE_LIST_ID — primary key of the price list, sourced from SO_PRICE_LISTS.PRICE_LIST_ID.
• NAME / DESCRIPTION — identifying and descriptive text for the price list.
• FREIGHT_TERMS — the meaning derived from SO_LOOKUPS for the freight terms code.
• ROUNDING_FACTOR / COMMENTS — pricing rounding rule and free-text remarks.
• START_DATE / END_DATE — the active window (START_DATE_ACTIVE, END_DATE_ACTIVE).
• "_DF" — the descriptive flexfield discriminator, hard-coded as '_DF:OE:SO_PRICE_LISTS:PRICELIST'.
• SECONDARY_PRICE_LIST_NAME / SECONDARY_PRICE_LIST_ID — the self-joined secondary price list reference.
• SHIP_METHOD_DESCRIPTION / SHIP_METHOD_CODE — freight method details from ORG_FREIGHT.
• PAYMENT_TERMS / TERM_ID — payment terms name and foreign key from RA_TERMS.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY.

Common Use Cases and Queries

Typical scenarios include price list reporting, validation of freight and payment term assignments, and integration extracts feeding downstream pricing systems. A representative query selecting active price lists with their secondary list and freight method:

SELECT PRICE_LIST_ID, NAME, FREIGHT_TERMS,
       SECONDARY_PRICE_LIST_NAME, SHIP_METHOD_DESCRIPTION,
       PAYMENT_TERMS, START_DATE, END_DATE
  FROM OEFV_PRICE_LISTS
 WHERE SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE + 1);

The view is frequently referenced in the Oracle EBS context of the search term so_price_lists, because its base table is SO_PRICE_LISTS. Analysts use it instead of writing the multi-table join directly, gaining freight term meanings, ship method descriptions, payment terms, and secondary price list names in a single read-only projection suitable for BI Publisher reports, OAF-based pages, and ETL extracts.