Results for “as_org_freight_active_v”

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

Overview

AS_ORG_FREIGHT_ACTIVE_V is a reporting view in the Oracle E-Business Suite Sales Foundation (AS) module. As its ETRM description states, it presents the set of active shipment methods — that is, freight/shipment method carrier codes that are currently enabled for a given organization. The view is defined to return only those freight records that have not been disabled, filtering out anything whose DISABLE_DATE is in the past. In EBS 12.1.1 and 12.2.2 the view has no documented owner and no documented referenced base objects beyond the underlying value-set view, indicating it is a lightweight presentation layer rather than a stored physical object.

Its practical role is to serve reporting, lookups, and integrations that need a clean list of usable freight methods without having to apply date logic themselves. Rather than querying the freight table directly and remembering to exclude expired carrier codes, downstream reports, LOVs, and interfaces can consume this view and receive only the currently valid rows.

Underlying Base Objects

The view text documented in ETRM is:

SELECT F.FREIGHT_CODE, F.ORGANIZATION_ID, F.DESCRIPTION
FROM   ORG_FREIGHT_VL F
WHERE  (DISABLE_DATE IS NULL) OR (DISABLE_DATE > SYSDATE)

The single documented source is ORG_FREIGHT_VL, the translated ("_VL") view over the organization freight / shipment method definition. ORG_FREIGHT_VL exposes the language-dependent attributes (such as DESCRIPTION) alongside the base freight attributes (FREIGHT_CODE, ORGANIZATION_ID, DISABLE_DATE). No other base tables are documented for this view in ETRM 12.2.2. The ETRM record also notes that the view is "not implemented in this database" in the referenced environment, meaning its definition exists in metadata but the object itself was not created there — a common situation in partially provisioned or non-Sales-Foundation instances.

Key Columns

• FREIGHT_CODE — The shipment method / carrier code, inherited from ORG_FREIGHT_VL. This is the primary identifier used on orders, deliveries, and shipping documents to denote the chosen freight method.
• ORGANIZATION_ID — The organization (inventory/operating unit) to which the freight method belongs. Freight methods are organization-scoped, so the same code can exist in multiple organizations.
• DESCRIPTION — The translated, user-facing description of the freight method, sourced from the _VL layer so that it returns in the session's language.

The DISABLE_DATE column, while used in the filter, is not projected by the view. The effective filter returns records where the disable date is either null (never disabled) or still in the future relative to SYSDATE.

Common Use Cases and Queries

Typical uses include populating freight-method selection lists on order and shipping reports, validating carrier codes in interface staging, and reconciling active shipment methods per organization before freight interfaces run. A representative query:

SELECT freight_code,
       organization_id,
       description
FROM   as_org_freight_active_v
WHERE  organization_id = :org_id
ORDER  BY freight_code;

Because the view already excludes expired methods, callers do not need to add disable-date predicates. Analyses of carrier coverage can be built with :

SELECT organization_id, COUNT(*) AS active_methods
FROM   as_org_freight_active_v
GROUP  BY organization_id;

Where the view is not implemented, the equivalent result can be obtained directly from ORG_FREIGHT_VL using the same DISABLE_DATE filter.