Results for “ahl_osp_orders_tl”

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

Overview

Within Oracle E-Business Suite, the table AHL.AHL_OSP_ORDERS_TL is the translatable (language) companion to the base entity table AHL_OSP_ORDERS_B. It belongs to the AHL product, Complex Maintenance Repair and Overhaul, which supports the planning and execution of depot-level maintenance and external service processing. In the standard EBS translation pattern, the _B table stores language-independent attributes and the _TL table stores the corresponding language-dependent descriptive columns, one row per installed or installed-translation language. As documented in ETRM for 12.2.2, its stated purpose is exactly "Translatable Table for AHL_OSP_ORDERS_B."

The object carries a heuristic Data Vault classification of satellite-leaning. In Data Vault modeling terms, this suggests treating AHL_OSP_ORDERS_TL as a satellite hanging off the order hub represented by AHL_OSP_ORDERS_B, with the natural business key supplied by the order identifier and the language code, rather than as an independent hub or link. The classification is a modeling suggestion derived from foreign-key structure and is not a functional designation used by the application itself.

Key Information Stored

• OSP_ORDER_ID — Surrogate identifier for the outside-processing order. Together with LANGUAGE it forms the composite primary key AHL_OSP_ORDERS_TL_PK, and it is also the foreign key to AHL_OSP_ORDERS_B.OSP_ORDER_ID.
• LANGUAGE — Language code of the translated row; the second component of the composite primary key and unique index AHL_OSP_ORDERS_TL_U1.
• DESCRIPTION — The principal language-dependent descriptive text associated with the OSP order; this is the primary translated column carried in this table.
• SOURCE_LANG — Language of the source row from which a translation was derived, used by the translation framework to track provenance.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, applying multi-org/security-group access control to the row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit trail columns identifying when and by whom the row was last changed.
• CREATION_DATE, CREATED_BY — Standard audit columns recording row creation.

The documented physical schema contains ten columns in total. The business-key candidate is uniquely identified by the index AHL_OSP_ORDERS_TL_U1 over (OSP_ORDER_ID, LANGUAGE), which mirrors the primary key constraint.

Common Use Cases and Queries

The typical reporting pattern joins the translation table back to the base table while filtering on a single language to avoid duplicate result rows. For example, to retrieve the description of an outside-processing order in U.S. English:

• SELECT b.osp_order_id, t.description FROM ahl.ahl_osp_orders_b b, ahl.ahl_osp_orders_tl t WHERE b.osp_order_id = t.osp_order_id AND t.language = USERENV('LANG');
• Maintenance reporting that must display order text in the session language relies on this join, since the base table alone contains no translated descriptive column.
• Translation-completeness audits compare the distinct LANGUAGE values present in the _TL table against the set of installed languages in FND_LANGUAGES to detect missing or untranslated order records.
• Security-group-scoped extracts filter on SECURITY_GROUP_ID to restrict visible orders to the appropriate operating unit or security context.

Related Objects

• AHL_OSP_ORDERS_B — Base entity table; join on AHL_OSP_ORDERS_TL.OSP_ORDER_ID = AHL_OSP_ORDERS_B.OSP_ORDER_ID. This is the parent in the documented foreign-key relationship.
• FND_SECURITY_GROUPS — Referenced by AHL_OSP_ORDERS_TL.SECURITY_GROUP_ID, governing row-level security access.
• FND_LANGUAGES — Supplies the installed-language list against which the LANGUAGE column is validated in translation audits.
• AHL_OSP_ORDERS_TL_PK / AHL_OSP_ORDERS_TL_U1 — The primary key constraint and unique index over (OSP_ORDER_ID, LANGUAGE) that enforce one translation row per order per language.
• AHL AHL_OSP_ORDERS — Associated AHL order entities and dependent OSP processing objects that reference the order identifier maintained in the base table.