Search Results oe_frght_terms_active_v




Overview
Explore in AI Chat

Overview

The OE_FRGHT_TERMS_ACTIVE_V view is a reporting and integration object within the Oracle Order Management (ONT) module of Oracle E-Business Suite, owned by the APPS schema. As documented in the ETRM metadata for releases 12.1.1 and 12.2.2, its stated purpose is to expose freight terms. Specifically, it presents the set of freight terms lookup values that are currently active, filtering the underlying lookup repository so that only enabled lookup codes whose active date range encompasses the current system date are surfaced. This makes the view a convenient, business-ready source of valid freight term values without requiring callers to re-implement the standard EBS lookup validation logic themselves.

Because it is a view rather than a base table, it carries no storage of its own. It is a lightweight, read-only projection intended for queries, concurrent programs, custom reports, interfaces, and integrations that need to resolve or validate the freight terms an order or shipment can carry. Any change made to the underlying lookup configuration (for example, disabling a code or altering its start/end dates) is immediately reflected the next time the view is queried.

Underlying Base Objects

The view is defined entirely over a single documented base object, OE_LOOKUPS, which itself is a view within the ONT schema family. The view text supplied in the ETRM documentation confirms this dependency:

  • OE_LOOKUPS — the sole referenced base object. It stores the lookup configuration for the FREIGHT_TERMS lookup type, including the meaning, lookup code, description, enabled flag, and active date range.

The definition applies a fixed filter on LOOKUP_TYPE = 'FREIGHT_TERMS' and ENABLED_FLAG = 'Y', and further constrains the row to fall within the active date window using a BETWEEN predicate. This dependency means the view inherits the semantics and profile of OE_LOOKUPS and cannot return values beyond those maintained for the FREIGHT_TERMS lookup type.

Key Columns

The view exposes five columns, each carrying a specific meaning drawn from the underlying lookup record:

  • FREIGHT_TERMS — the display meaning of the lookup, i.e., the descriptive value presented to users.
  • FREIGHT_TERMS_CODE — the lookup code used as the stored code value in order and shipping records.
  • START_DATE_ACTIVE — the date from which the term becomes active.
  • END_DATE_ACTIVE — the date on which the term ceases to be active.
  • DESCRIPTION — additional descriptive text associated with the lookup.

Common Use Cases and Queries

Typical scenarios include populating freight terms in custom order-entry pages, validating that a value entered on an interface is a currently active term, and driving lookups in reports or integrations.

  • List all active freight terms: 
    SELECT freight_terms, freight_terms_code
FROM   apps.oe_frght_terms_active_v
ORDER BY freight_terms;
  • Resolve a code to its meaning: 
    SELECT freight_terms
FROM   apps.oe_frght_terms_active_v
WHERE  freight_terms_code = :p_code;
  • Validation in an interface — confirm the supplied code exists in the active set before loading.

Because the active date window is evaluated against TRUNC(SYSDATE) at query time, the result set is inherently date-sensitive, ensuring only valid terms are returned for the current business date.