Search Results freight_terms




Overview
Explore in AI Chat

Overview

APPS.SO_FREIGHT_TERMS_ACTIVE_V is a reporting view in the Oracle E-Business Suite Order Management (ONT) schema. It exposes the set of currently active freight terms lookup values that are available for assignment to sales orders, order lines, and related order management transactions. Freight terms (also referred to by the seeded lookup type FREIGHT_TERMS) determine which party bears the cost and responsibility of shipping goods, and the view provides a filtered, denormalized, read-only presentation of those lookup values.

The view is intended for reporting, validation, list-of-values, and integration scenarios where only enabled and date-effective freight terms should be presented. Because it resolves directly from the SO_LOOKUPS synonym, it does not introduce additional persistence; it is a lightweight, runtime-filtered projection of lookup metadata. The view carries Oracle's proprietary and confidential classification per ETRM documentation.

Underlying Base Objects

The documented view is defined over the following base objects:

  • SO_LOOKUPS (SYNONYM) — the synonym resolving to the Order Management lookup table that stores lookup types, lookup codes, meanings, descriptions, enabled flags, and effective date ranges.
  • FND_GLOBAL (PACKAGE) — referenced as an object dependency, typically supplying session context such as user ID, responsibility, and application for security and profile resolution during query execution.

The view filters SO_LOOKUPS by the seeded lookup type FREIGHT_TERMS, restricting rows to those marked ENABLED_FLAG = 'Y'. It further constrains rows using effective dating: TRUNC(SYSDATE) must fall between NVL(START_DATE_ACTIVE, TRUNC(SYSDATE)) and NVL(END_DATE_ACTIVE, TRUNC(SYSDATE)), allowing null start or end dates to be treated as open-ended.

Key Columns

  • FREIGHT_TERMS — the display meaning of the freight term (aliased from MEANING); this is the user-facing text shown in lists of values and reports.
  • FREIGHT_TERMS_CODE — the lookup code (aliased from LOOKUP_CODE) that is stored on order and transaction records; it is the persistent value used in the underlying data model.
  • DESCRIPTION — the descriptive text associated with the lookup entry, providing additional context for the freight term.

Filtering columns from SO_LOOKUPS (LOOKUP_TYPE, ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE) are applied in the view definition and are not exposed as output columns.

Common Use Cases and Queries

The view is commonly used in reports and integrations that require a validated list of freight terms. Typical example:

  • Populating a list of values for a custom freight-terms parameter in a concurrent program or OAF page.
  • Joining to order headers or lines to translate a stored FREIGHT_TERMS_CODE into its descriptive meaning for reporting.
  • Validating inbound interface data before insert into order management tables.

Sample query:

SELECT freight_terms_code, freight_terms, description FROM apps.so_freight_terms_active_v ORDER BY freight_terms;

A join to resolve codes on order lines:

SELECT l.order_number, l.freight_terms_code, f.freight_terms FROM oe_order_lines_all l, apps.so_freight_terms_active_v f WHERE l.freight_terms_code = f.freight_terms_code (+);

Because rows are date-effective, any application or report consuming the view automatically reflects only freight terms active as of the query execution date, which supports consistent, current-state reporting.