Search Results org_freight_tl_u1

Overview

INV.ORG_FREIGHT_TL is the translation (TL) table that stores language-specific descriptive information for freight carriers defined in Oracle Inventory. Carriers are created and maintained through the Freight Carriers window in Oracle Inventory, and the base definition resides in INV.ORG_FREIGHT, while ORG_FREIGHT_TL holds the translated freight code name and description keyed by language. The table also carries the freight charge distribution account, which, together with the freight carrier code, is consumed during inter-organization transfers.

The object is owned by the INV schema and resides in the APPS_TS_SEED tablespace, consistent with its role as a seeded setup entity. Its primary key, ORG_FREIGHT_TL_PK, is composed of FREIGHT_CODE, ORGANIZATION_ID, and LANGUAGE, confirming the multi-lingual, multi-organization nature of the data. From a Data Vault modeling perspective, the mined relationship classification is a link: the table connects a freight carrier business key to an organization and a language, and it references GL_CODE_COMBINATIONS and MTL_PARAMETERS.

Key Information Stored

The composite primary key is the true row identifier, but the documented unique index ORG_FREIGHT_TL_U1 (FREIGHT_CODE, ORGANIZATION_ID, LANGUAGE) is the authoritative business-key candidate and enforces exactly the same uniqueness constraint as the primary key. The most significant columns include:

• FREIGHT_CODE (VARCHAR2(25)) — the freight carrier business key; part of the PK and U1.
• ORGANIZATION_ID (NUMBER) — organization identifier; part of the PK and U1; references MTL_PARAMETERS.
• LANGUAGE (VARCHAR2) — the language of the row, sourced from FND_LANGUAGES.LANGUAGE_CODE; part of the PK and U1.
• FREIGHT_CODE_TL (VARCHAR2(25)) — the translated freight code text shown to the user.
• SOURCE_LANG (VARCHAR2) — the actual/native source language of the row, used to track the original language when a translation is applied.
• DESCRIPTION (VARCHAR2(80)) — the translated freight code description.
• DISABLE_DATE (DATE) — the date on which the freight carrier becomes inactive.
• DISTRIBUTION_ACCOUNT (NUMBER) — the freight charge distribution account, referencing GL_CODE_COMBINATIONS.
• LAST_UPDATE_DATE / LAST_UPDATED_BY / CREATION_DATE / CREATED_BY / LAST_UPDATE_LOGIN — standard Who columns for audit and change-tracking.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — descriptive flexfield structure and segments.
• GLOBAL_ATTRIBUTE_CATEGORY and GLOBAL_ATTRIBUTE1–20 — global descriptive flexfield columns reserved for country-specific extensions.
• PARTY_ID (NUMBER) — trading partner/party reference, typically linking a carrier to a TCA party.

The table contains 51 documented columns in total; the remainder are additional attribute, flexfield, and audit columns following the same pattern.

Common Use Cases and Queries

Typical queries join ORG_FREIGHT_TL to its base table to retrieve translated carrier names for a specific organization, and to GL_CODE_COMBINATIONS to resolve the distribution account. A representative pattern:

• SELECT fr.freight_code, ftl.freight_code_tl, ftl.description, fr.distribution_account FROM inv.org_freight fr, inv.org_freight_tl ftl WHERE fr.freight_code = ftl.freight_code AND fr.organization_id = ftl.organization_id AND ftl.language = USERENV('LANG');
• Reporting on active carriers filtering out rows where DISABLE_DATE IS NOT NULL or DISABLE_DATE <= SYSDATE.
• Validating translation coverage by comparing FREIGHT_CODE counts between ORG_FREIGHT (base) and ORG_FREIGHT_TL per LANGUAGE to find missing translations.
• Resolving the freight charge distribution account for inter-organization transfers by joining DISTRIBUTION_ACCOUNT to GL_CODE_COMBINATIONS for natural account reporting.
• Auditing setup changes using LAST_UPDATE_DATE and LAST_UPDATED_BY for seed data migration and reconciliation between environments.

Related Objects

The most significant related objects, based on the documented foreign key and primary key relationships, are:

• INV.ORG_FREIGHT — the base (non-translated) freight carrier definition; joined on FREIGHT_CODE and ORGANIZATION_ID.
• INV.MTL_PARAMETERS — referenced by ORGANIZATION_ID via foreign key.
• GL.GL_CODE_COMBINATIONS — referenced by DISTRIBUTION_ACCOUNT via foreign key, providing the account for freight charge distribution.
• FND_LANGUAGES — source of LANGUAGE values (LANGUAGE_CODE) used in the PK and U1.
• INV.ORG_FREIGHT_TL_PK / ORG_FREIGHT_TL_U1 — the primary key and unique index that enforce row uniqueness on FREIGHT_CODE, ORGANIZATION_ID, and LANGUAGE.
• TCA party objects (via PARTY_ID) — link freight carriers to trading partners where party integration is enabled.