Results for “as_freight_carriers_active_v”

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

Overview

The AS_FREIGHT_CARRIERS_ACTIVE_V view belongs to the AS – Sales Foundation product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes a consolidated, read-only list of currently active freight carriers that can be selected during order entry, shipping, and related logistics transactions. The view's documented purpose is the presentation of "active freight carriers," meaning carriers that have not been disabled or whose disable date has not yet passed.

Because the view unions carriers originating from two distinct sources—organization-level freight definitions (ORG_FREIGHT_VL) and a seeded lookup list (AS_LOOKUPS)—it provides a single result set that report authors, integrations, and Oracle Order Management validation logic can query without reconciling multiple tables themselves. The ETRM metadata records the object as "Not implemented in this database," indicating that in the environment from which the documentation was generated, the view was not physically present or was not created; deployments should therefore verify existence before relying on it.

Underlying Base Objects

The documented view text is defined over two base objects:

• ORG_FREIGHT_VL — the organization-level freight carrier (ship method) definition table, which supplies the freight code and description.
• ORG_ORGANIZATION_DEFINITIONS — the organization master, joined on ORGANIZATION_ID and supplying the organization name; the join is an outer join (O.ORGANIZATION_ID(+)).
• AS_LOOKUPS — the Sales Foundation lookup table, from which lookup codes of type FREIGHT_CARRIER with ENABLED_FLAG = 'Y' are appended.

No base objects are separately documented in the ETRM metadata beyond those visible in the view text. Note that the metadata header lists the referenced base objects as "none documented."

Key Columns

• FREIGHT_CODE — the carrier or ship method code. Sourced from ORG_FREIGHT_VL.FREIGHT_CODE for organization-defined carriers and from AS_LOOKUPS.LOOKUP_CODE for lookup-based carriers.
• DESCRIPTION — the descriptive name of the carrier, taken from ORG_FREIGHT_VL.DESCRIPTION or AS_LOOKUPS.MEANING.
• FREIGHT_CARRIER_SOURCE_CODE — a literal discriminator: 'OE' for carriers originating from the Order Entry organization freight table, and 'OSM' for carriers originating from the Sales Foundation lookup (AS_LOOKUPS).
• ORGANIZATION_NAME — the operating unit or inventory organization name from ORG_ORGANIZATION_DEFINITIONS. For lookup-sourced rows this value is a literal NULL.

Common Use Cases and Queries

The view is typically queried to drive carrier list-of-values (LOV) prompts, to validate free-text carrier entries on orders, or to report active carrier coverage across organizations.

A representative query retrieves all active carriers grouped by source:

• SELECT freight_code, description, freight_carrier_source_code, organization_name FROM AS_FREIGHT_CARRIERS_ACTIVE_V ORDER BY freight_code;

To isolate organization-specific carriers (the 'OE' source), filter on the discriminator column:

• SELECT freight_code, description FROM AS_FREIGHT_CARRIERS_ACTIVE_V WHERE freight_carrier_source_code = 'OE' AND organization_name = :org_name;

Conversely, to obtain centrally seeded lookup-based carriers ('OSM'):

• SELECT freight_code, description FROM AS_FREIGHT_CARRIERS_ACTIVE_V WHERE freight_carrier_source_code = 'OSM';

Where a user searches for a specific logistics provider by name—for example to confirm whether a carrier such as "Freja Transport and Logistics AB USA" is registered and active—the pattern would be SELECT freight_code, description, organization_name FROM AS_FREIGHT_CARRIERS_ACTIVE_V WHERE UPPER(description) LIKE '%FREJA%';. Because the view exposes only carrier-to-organization relationships, contact telephone numbers are not stored here; those details reside on supplier or address records in Oracle Payables or the trading partner master, not in this AS view.