Results for “invfv_freight_carriers”

20 results




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

Overview

The APPS.INVFV_FREIGHT_CARRIERS view is an Inventory (INV) module object that exposes freight carrier definitions configured per inventory organization within Oracle E-Business Suite 12.1.1 and 12.2.2. Freight carriers in EBS represent the transportation vendors used to move goods inbound and outbound, and their configuration is stored at the organization level in the ORG_FREIGHT table. The view consolidates carrier attributes with organization naming and general ledger account information, producing a reporting-friendly record set that presents a carrier code, its owning inventory organization, the descriptive organization name, an optional disable date, and the distribution account used for freight accounting. The "_KF:SQLGL:GL#:GLC" and "_SEC:MOF.ORGANIZATION_ID" tokens in the view text denote EBS Flexfield and security constructs respectively: the former supplies the key flexfield display value for the distribution account, and the latter enforces organization-level security through the MOF.ORGANIZATION_ID discriminator. This makes the view suitable both for operational inquiry and for joining into broader freight-cost and logistics reporting. Note that the view definition declares WITH READ ONLY, so consumers cannot perform DML against it.

Underlying Base Objects

The view is defined over four referenced base objects, each appearing under the APPS schema as a synonym in 12.2.2:

  • ORG_FREIGHT — the primary driver table (aliased MOF in the view text), holding freight carrier records keyed by FREIGHT_CODE and ORGANIZATION_ID.
  • MTL_PARAMETERS (aliased MP) — the inventory parameters table, joined on ORGANIZATION_ID to supply the organization code.
  • HR_ALL_ORGANIZATION_UNITS (aliased HOU) — the organization definitions, joined on ORGANIZATION_ID to provide the organization name.
  • GL_CODE_COMBINATIONS (aliased GLC) — the accounting flexfield combinations, outer-joined via DISTRIBUTION_ACCOUNT to resolve the freight distribution account.

The join pattern is an inner join across ORG_FREIGHT, MTL_PARAMETERS, and HR_ALL_ORGANIZATION_UNITS, with an outer join (+) to GL_CODE_COMBINATIONS, allowing carrier rows to be returned even where no valid distribution account combination exists.

Key Columns

  • CARRIER_NAME — the freight carrier code (MOG.FREIGHT_CODE), the primary business identifier for the carrier.
  • ORGANIZATION_ID — inventory organization that owns the carrier definition; also the security discriminator.
  • ORGANIZATION_CODE — the short organization code from MTL_PARAMETERS.
  • ORGANIZATION_NAME — the full organization name from HR_ALL_ORGANIZATION_UNITS.
  • DESCRIPTION — free-text description of the carrier.
  • INACTIVE_DATE — the disable date, after which the carrier should not be selected.
  • DISTRIBUTION_ACCOUNT — the CODE_COMBINATION_ID used to charge freight costs.
  • "_KF:DIST_ACC_NUM:_CO" — a descriptive flexfield-style rendered value for the distribution account combination.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard audit columns.

Common Use Cases and Queries

Typical uses include validating carrier setup per organization, auditing inactive carriers, and correlating freight carriers with their accounting distributions. A basic listing follows:

SELECT carrier_name,
       organization_code,
       organization_name,
       description,
       inactive_date
FROM   apps.invfv_freight_carriers
WHERE  organization_id = :org_id
ORDER  BY carrier_name;

To identify active carriers only:

SELECT carrier_name, organization_name, inactive_date
FROM   apps.invfv_freight_carriers
WHERE  inactive_date IS NULL;

To review distribution account assignments:

SELECT carrier_name, organization_code, distribution_account
FROM   apps.invfv_freight_carriers
WHERE  distribution_account IS NOT NULL;

Because the view is read-only and carries organization security, queries executed under a responsibility restricted to one or more organizations will return only the carriers visible to that organization set. This view is not the standard freight carrier maintenance form; carrier creation and update occur through the Inventory setup windows that write directly to ORG_FREIGHT.