Results for “revision_notes”

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

Overview

AHL_ROUTES_TL is the translation (language) table for Maintenance Routes within the Oracle E-Business Suite Complex Maintenance Repair and Overhaul (AHL) module. In Oracle EBS, "TL" tables store the language-dependent attributes of a base or "B" table, allowing the same business entity to be rendered in multiple installed languages. This table therefore holds the translated descriptive text for Routes, whose language-independent definition resides in AHL_ROUTES_B.

From a Data Vault modeling perspective, the mined foreign-key structure classifies AHL_ROUTES_TL as satellite-leaning. It does not act as a hub or a link; instead it carries descriptive, context-dependent attributes that accompany the Route hub. Each row is a descriptive satellite keyed to a Route identifier and a language code, providing locale-specific text rather than the core identity of the Route itself.

Key Information Stored

The table is owned by the AHL schema and, in the documented 12.2.2 physical schema, contains 13 columns. The most significant are listed below.

• ROUTE_ID — Surrogate reference to the parent Route in AHL_ROUTES_B. Part of the composite primary key.
• LANGUAGE — The installed language code for the translated text. Part of the composite primary key.
• TITLE — The translated title of the Route; the primary business-visible attribute.
• REMARKS — Translated free-text remarks or description for the Route.
• REVISION_NOTES — Translated notes describing revisions or changes.
• APPROVER_NOTE — Translated approval commentary associated with the Route.
• SOURCE_LANG — Identifier of the language from which the translation was derived, supporting multilingual maintenance.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, applying Oracle's multi-organization/security-group filtering.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who last changed the row and when.
• CREATION_DATE, CREATED_BY — Standard EBS audit columns recording row creation.

The primary key is AHL_ROUTES_TL_PK (ROUTE_ID, LANGUAGE). A unique index, AHL_ROUTES_TL_U1 (ROUTE_ID, LANGUAGE), serves as the business-key candidate, meaning a Route may have at most one translated row per language. The surrogate identity of the Route itself lives in AHL_ROUTES_B, while the composite key here identifies the specific language rendering.

Common Use Cases and Queries

AHL_ROUTES_TL is typically queried to present Route descriptions in a user's chosen language, to audit translations, or to join Route definitions with locale-specific text for reporting. A common pattern restricts retrieval to a single language while joining back to the parent table.

• Retrieve a translated Route title for the current session language: SELECT r.route_id, t.title, t.remarks FROM ahl_routes_b r JOIN ahl_routes_tl t ON t.route_id = r.route_id WHERE t.language = USERENV('LANG').
• List all available translations for a given Route: SELECT language, title FROM ahl_routes_tl WHERE route_id = :route_id.
• Identify Routes missing a translation in a required language by comparing AHL_ROUTES_B against AHL_ROUTES_TL keyed on ROUTE_ID and LANGUAGE.
• Report translation currency by examining LAST_UPDATE_DATE and SOURCE_LANG for each language variant.

Because the table is security-group aware, production queries normally also constrain SECURITY_GROUP_ID through the standard Oracle security profile, which is applied automatically in most AHL forms and views.

Related Objects

• AHL_ROUTES_B — The base, language-independent Route table; joined on ROUTE_ID. The foreign key AHL_ROUTES_TL.ROUTE_ID references AHL_ROUTES_B.
• FND_SECURITY_GROUPS — Referenced by AHL_ROUTES_TL.SECURITY_GROUP_ID; enforces the security-group assignment of translated rows.
• AHL_ROUTES_VL — The typical language-view that unions or joins AHL_ROUTES_B with AHL_ROUTES_TL to expose the correct translation to forms and reports.
• AHL_ROUTES_B groups and associated Route definition tables — Travel down the foreign-key chain from AHL_ROUTES_B to the related operations, resources, and work-order structures that consume Route data.
• AHL_WORKORDERS / Route-operation tables — Downstream MRO objects that reference Routes and therefore depend indirectly on the translated attributes defined here.

For DBA purposes, the table is VALID with a 13-column documented structure, primary key AHL_ROUTES_TL_PK, and unique index AHL_ROUTES_TL_U1; standard EBS audit and ALTER triggers may also be attached, and translations are usually maintained through the AHL Route setup forms rather than by direct DML.