Results for “freight_code”

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

Overview

ORG_FREIGHT_CODE_ALL_V is a database view owned by the APPS schema in Oracle E-Business Suite, residing within the Inventory (INV) product module. It is documented as VALID and appears in the ETRM reference metadata for both 12.1.1 and 12.2.2. The view's documented description is the terse notation "10SC ONLY," indicating that the object was defined for a specific restricted purpose, most likely a single-organization or single-currency configuration scenario associated with a legacy or customer-specific implementation, rather than as a general-purpose Inventory deliverable.

Functionally, the view presents freight code reference data in combination with the owning organization identifier. It serves as a reporting and integration surface that exposes freight code definitions scoped by inventory organization. Because the view carries an _ALL_V suffix, it is intended to present a cross-organizational or organization-aware projection of its underlying data, allowing callers to filter and join on ORGANIZATION_ID without needing to know the physical partitioning of the base table.

Underlying Base Objects

The view's documented base object is ORG_FREIGHT, referenced through a SYNONYM. ORG_FREIGHT is the Inventory table that stores freight code definitions for inventory organizations. The view is defined with a simple projection, selecting three columns directly from this base table with no joins, aggregations, or filtering logic:

• FREIGHT_CODE
• DESCRIPTION
• ORGANIZATION_ID

Because there are no joins in the view text, the view is effectively a thin, column-restricted pass-through over ORG_FREIGHT. This has practical consequences: the view inherits the base table's row-level content, including any multi-organization rows present in ORG_FREIGHT, and inherits the base table's security, indexing, and performance characteristics. Any change to the underlying table's data is immediately visible through the view.

Key Columns

• FREIGHT_CODE — The freight code identifier carried on the underlying ORG_FREIGHT record. This is the primary business key used to reference a freight charge or carrier arrangement in inventory and receiving transactions.
• DESCRIPTION — The descriptive text associated with the freight code, typically the user-facing name or explanation of the charge.
• ORGANIZATION_ID — The inventory organization to which the freight code definition belongs. This column is what gives the view its organization-aware character and enables callers to filter to a single operating unit or inventory organization.

Common Use Cases and Queries

Typical uses include reporting on freight codes by organization, validating that a freight code exists before it is assigned on a transaction, and populating list-of-values or integration payloads where the description and organization context are both required.

Retrieve all freight codes for a given organization:

SELECT freight_code, description
FROM   apps.org_freight_code_all_v
WHERE  organization_id = :p_org_id
ORDER  BY freight_code;

Join the view to inventory organization context to obtain the organization name alongside each freight code:

SELECT f.freight_code,
       f.description,
       o.organization_name
FROM   apps.org_freight_code_all_v f,
       apps.org_organization_definitions o
WHERE  f.organization_id = o.organization_id
AND    f.organization_id = :p_org_id;

Because the view is documented as "10SC ONLY" and is a direct projection of ORG_FREIGHT, consumers should confirm with their implementation whether it is supported in their specific configuration before building production dependencies on it. Where the same data is required in a standard configuration, querying ORG_FREIGHT directly with an explicit ORGANIZATION_ID filter is generally the safer and equally accurate alternative.