Search Results work_elem_id




Overview
Explore in AI Chat

Overview

AMW.AMW_CTRL_EXT_TL is a translated (TL) child table within the Oracle E-Business Suite Discrete Manufacturing / Oracle Complex Maintenance, Repair and Overhaul (eAM) schema, AMW. It stores the language-specific, extensible attribute values attached to maintenance work order controls. Where the base table AMW_CTRL_EXT holds the language-independent extension header, the _TL variant persists the descriptive, translatable text values for each defined extension attribute slot, enabling multi-language display of user-defined control attributes across a global enterprise.

The table is owned by the AMW schema, resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10, and is registered in FND Design Data as AMW.AMW_CTRL_EXT_TL. Its reported status is VALID in both 12.1.1 and 12.2.2 file systems.

The heuristic Data Vault classification mined from the foreign-key structure is standalone; that is, no dependent hub or link relationships were mined. In a Data Vault modeling suggestion, this table would be treated as a satellite-like descriptive structure keyed by a work/control reference rather than as an independent hub or link.

Key Information Stored

The table contains 53 documented columns and, following the EBS standard, includes the five WHO audit columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE. The most significant columns are:

  • EXTENSION_ID (NUMBER) — surrogate identifier for the extension record; the primary key candidate.
  • WORK_ID (NUMBER) — reference to the maintenance work order being extended.
  • WORK_ELEM_ID (NUMBER) — work element within the work order; the column most often cited when users search this table.
  • CONTROL_ID (NUMBER) — the control to which the extensible attributes are attached; this is the column appearing in the documented foreign key relationship.
  • WORK_TYPE_ID (NUMBER) — the work type context for the extension.
  • ATTR_GROUP_ID (NUMBER) — attribute group grouping the extensible slots.
  • SOURCE_LANG (VARCHAR2 30) — the source language of the translation.
  • LANGUAGE (VARCHAR2 30) — the language of this row's translated values; the TL discriminator.
  • TL_EXT_ATTR1 through TL_EXT_ATTR40 (VARCHAR2 1000) — the translatable extensible attribute values, providing up to forty user-defined slots.

The unique / business key is typically the combination of the parent extension identity plus LANGUAGE (for example EXTENSION_ID with WORK_ID, WORK_ELEM_ID, CONTROL_ID, and LANGUAGE).

Common Use Cases and Queries

Typical uses center on retrieving user-defined control attributes for a work order or work element in a specific language, and on reporting extension values across work orders. Sample patterns:

  • Retrieve translated attributes for a work element:
    SELECT EXTENSION_ID, WORK_ELEM_ID, LANGUAGE FROM AMW_CTRL_EXT_TL WHERE WORK_ELEM_ID = :elem;
  • Join extension headers to their translations on the surrogate and language keys:
    SELECT h.EXTENSION_ID, t.LANGUAGE FROM AMW_CTRL_EXT_B h JOIN AMW_CTRL_EXT_TL t ON h.EXTENSION_ID = t.EXTENSION_ID;
  • Filter by control context using the documented FK column CONTROL_ID.
  • Restrict to a single language via the LANGUAGE column for reporting or export.

Related Objects

  • CST_REVENUE_COGS_CONTROL — referenced by the documented foreign key AMW_CTRL_EXT_TL.CONTROL_ID → CST_REVENUE_COGS_CONTROL.
  • AMW_CTRL_EXT_B (base, language-independent extension header) — parent of the translated rows, joined by EXTENSION_ID.
  • AMW_CTRL_EXT family of extension value tables — holds the non-translated attribute values and is frequently queried alongside the _TL table.
  • WIP / maintenance work order tables referenced through WORK_ID and WORK_TYPE_ID.
  • FND_LANGUAGES — for validating the LANGUAGE and SOURCE_LANG values.