Search Results freight_carrier




Overview
Explore in AI Chat

Overview

The view OE_FRGHT_CARR_ACTIVE_V is an Oracle E-Business Suite database object owned by the APPS schema and classified under the ONT (Order Management) product family. It exists in both Oracle EBS 12.1.1 and 12.2.2, where it is registered with a status of VALID in the ETRM (E-Business Suite Technical Reference Manual) repository. Its documented description is plainly stated as "No longer used," which indicates that Oracle has deprecated the object, and it remains in the schema solely for backward compatibility with existing customizations or integrations that may still reference it.

Functionally, the view presents a filtered list of freight carriers that are considered currently active for a given inventory organization. It is built over the ORG_FREIGHT synonym and applies a date-based filter so that only carriers whose disable date is in the future (or is null) are returned. This makes it a convenient, read-only construct for identifying shipping and freight carriers that are eligible for use on order, shipment, and delivery transactions within the Order Management and Shipping execution flows.

Underlying Base Objects

The single documented referenced base object for this view is ORG_FREIGHT, which is exposed as a synonym in the APPS schema. ORG_FREIGHT is the organization-level freight and carrier definition table, holding the carrier codes, descriptions, enable and disable dates, and the owning organization identifier. The view does not introduce joins to any additional tables; instead, it projects a subset of columns from ORG_FREIGHT and applies a predicate to restrict the returned rows to active carriers. Because the view reads directly from ORG_FREIGHT, any change to a carrier's disable date in the base table is immediately reflected in the view's output without further maintenance. No materialization, aggregation, or denormalization is performed.

Key Columns

  • FREIGHT_CARRIER — A display-oriented value produced by NVL(DESCRIPTION, FREIGHT_CODE). It returns the carrier description when available, falling back to the carrier code when the description is null. This is the human-readable label typically shown in LOVs and reports.
  • FREIGHT_CODE — The short code identifying the freight carrier, as defined in ORG_FREIGHT. This is the value most commonly stored on transactional records.
  • DESCRIPTION — The descriptive name of the freight carrier. It may be null, in which case FREIGHT_CARRIER substitutes the code.
  • ORGANIZATION_ID — The inventory organization to which the carrier definition belongs. It supports multi-organization filtering and is essential when a query must return carriers for a specific operating unit or warehouse.

Common Use Cases and Queries

Although flagged as no longer used, the view remains a straightforward source for reporting and integration scenarios that require a list of active carriers per organization. A typical query retrieves the display name and code for a specified organization:

  • SELECT freight_carrier, freight_code FROM oe_frght_carr_active_v WHERE organization_id = :org_id;
  • SELECT freight_code, description FROM oe_frght_carr_active_v ORDER BY 1;

Because the active filter is embedded in the view definition via TRUNC(SYSDATE) < TRUNC(NVL(DISABLE_DATE, SYSDATE+1)), consumers do not need to re-implement date logic. For new development, Oracle recommends querying ORG_FREIGHT directly with an equivalent predicate; existing reports and interfaces referencing OE_FRGHT_CARR_ACTIVE_V should be migrated to the base table to avoid reliance on a deprecated object.