Search Results org_freight_vl




Overview
Explore in AI Chat

Overview

ORG_FREIGHT_VL is an APPS-owned, read-only database view in Oracle E-Business Suite (documented for 12.1.1 and 12.2.2) belonging to the INV – Inventory product. It is the translation-language ("_VL") view of the inventory organization freight codes, presenting the freight carrier and freight charge definitions maintained per organization together with their translated descriptions. The view resolves foreign-language rows at runtime by filtering on the session language through USERENV('LANG'), so a user querying it sees the freight code description appropriate to the current login language without writing language-specific predicates.

Because freight codes drive freight charge calculation on purchasing, receiving, and inter-organization transfers, ORG_FREIGHT_VL is the canonical reporting surface for these definitions. Report writers, OAF pages, forms, and integration extracts should use ORG_FREIGHT_VL rather than ORG_FREIGHT_TL directly, since the view already applies the language filter and joins in the organization code from MTL_PARAMETERS.

Underlying Base Objects

The ETRM metadata documents two referenced base objects, both exposed through APPS synonyms: ORG_FREIGHT_TL and MTL_PARAMETERS. The view is defined with the equivalent of:

The translation filter LANGUAGE = USERENV('LANG') restricts output to a single language row per freight code/organization combination, eliminating the duplication a direct query on the TL table would otherwise produce.

Key Columns

  • ROW_ID – the ROWID of the underlying ORG_FREIGHT_TL row; a stable identifier for the translated record.
  • FREIGHT_CODE / FREIGHT_CODE_TL – the short code and its translated detail value. The user search term "freight_code_tl" corresponds to this column, which carries the language-specific representation of the freight code.
  • ORGANIZATION_ID / ORGANIZATION_CODE – the inventory organization owning the freight code; the code is resolved from MTL_PARAMETERS.
  • LANGUAGE / SOURCE_LANG – the language of the returned row and the source language of the record.
  • DESCRIPTION – description of the freight charge.
  • DISABLE_DATE – the date the freight code becomes inactive; null means active. Useful for filtering out obsolete definitions.
  • DISTRIBUTION_ACCOUNT – the accounting distribution account used when freight charges are recorded.
  • PARTY_ID – link to the trading partner (typically the carrier/vendor) associated with the freight code.
  • WHO columns – CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN for audit.
  • ATTRIBUTE1–15, ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1–20 – descriptive and global flexfield segments.

Common Use Cases and Queries

Typical scenarios include validating active freight codes per organization, building carrier/freight lookups for receiving integrations, and auditing distribution account assignments. The session language governs the returned description, so always run against the view rather than the TL table.

  • Retrieve all active freight codes for an organization: 
    SELECT freight_code, freight_code_tl, organization_code, description, party_id
FROM   apps.org_freight_vl
WHERE  organization_id = :org_id
AND    disable_date IS NULL;
  • Locate a freight code by its translated value: 
    SELECT organization_code, freight_code, freight_code_tl, description
FROM   apps.org_freight_vl
WHERE  UPPER(freight_code_tl) LIKE UPPER(:search_text || '%');
  • Confirm the accounting distribution account for a code: 
    SELECT freight_code, organization_code, distribution_account
FROM   apps.org_freight_vl
WHERE  freight_code = :freight_code
AND    organization_id = :org_id;

Because the underlying data resides in a translation table, DML is not permitted through the view; maintenance is performed via the Inventory setup forms or the ORG_FREIGHT_TL API.