Search Results freight_code_tl

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:

• ORG_FREIGHT_TL – the translation (TL) table holding freight code rows in each installed language; supplies FREIGHT_CODE, ORGANIZATION_ID, FREIGHT_CODE_TL, LANGUAGE, SOURCE_LANG, DESCRIPTION, DISABLE_DATE, DISTRIBUTION_ACCOUNT, WHO audit columns, the 15 descriptive flexfield (ATTRIBUTE1–15) columns, the GLOBAL_ATTRIBUTE flexfield columns, and PARTY_ID.
• MTL_PARAMETERS – the inventory organization parameters table; supplies ORGANIZATION_CODE and is joined on ORGANIZATION_ID (OFT.ORGANIZATION_ID = MP.ORGANIZATION_ID), so each row is presented with its owning organization's code.

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.