Results for “ahl_item_groups_vl”

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

Overview

In Oracle E-Business Suite 12.1.1 and 12.2.2, AHL_ITEM_GROUPS_VL is a public, key-language (VL) view owned by the APPS schema in the AHL – Complex Maintenance Repair and Overhaul product. It presents item group definitions maintained within the Enterprise Asset Management / MRO domain in a single, translation-aware row per logical record. The view is registered as VALID in the ETRM metadata and is documented for release 12.2.2.

The name incorporates two conventions. The _VL suffix designates a key flexfield style view that joins the base (language-independent) table to its translation table and filters translations by the session language. The view therefore returns the base attributes of each item group alongside the language-specific description and name translated into the language of the current user session. As a reporting and integration artifact, AHL_ITEM_GROUPS_VL is the supported read interface used by forms, concurrent programs, OBIEE/BI Publisher reports, and external integrations that need a denormalized, translation-resolved representation of item groups without writing the join manually.

Underlying Base Objects

The view is defined over two documented synonym objects:

• AHL_ITEM_GROUPS_B — the base table holding language-independent columns, aliased as AIGB in the view text.
• AHL_ITEM_GROUPS_TL — the translation table holding translatable columns (notably DESCRIPTION), aliased as AIGT.

The join predicate is AIGB.ITEM_GROUP_ID = AIGT.ITEM_GROUP_ID combined with AIGT.LANGUAGE = USERENV('LANG'). This ensures exactly one row per item group, produced in the language configured for the current session. The view publishes the base table's ROWID as ROW_ID, the standard WHO audit columns, the translated NAME and DESCRIPTION, and a set of descriptive and control columns. No user exit, function-based filter, or security predicate is present in the supplied view text; row-level access is governed by the underlying tables.

Key Columns

• ROW_ID — the row identifier derived from AHL_ITEM_GROUPS_B.ROWID, usable for row-based lookups and updates through the base table.
• ITEM_GROUP_ID — the primary key linking the base and translation rows; the principal join and lookup key for item groups.
• NAME — the item group name from the base table.
• DESCRIPTION — the translated long description sourced from AHL_ITEM_GROUPS_TL for the session language.
• STATUS_CODE, TYPE_CODE — status and classification of the item group, used to filter active or specific group types.
• SOURCE_ITEM_GROUP_ID — identifies a source/template item group from which this record was derived.
• OBJECT_VERSION_NUMBER — optimistic locking version, relevant to integrations and programmatic updates.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit (WHO) columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the DFF (descriptive flexfield) segment columns configured for item groups.

Common Use Cases and Queries

Typical scenarios include validating item group setup before MRO work order or asset maintenance processing, feeding item group lists into BI Publisher reports, and populating reference data in integration extracts. Because translation is resolved dynamically via USERENV('LANG'), the DESCRIPTION returned follows the connected user's session language.

List active item groups in the session language:

SELECT item_group_id, name, description, status_code, type_code
FROM   apps.ahl_item_groups_vl
WHERE  status_code = 'ACTIVE'
ORDER  BY name;

Resolve a single group by identifier or name:

SELECT item_group_id, name, description, source_item_group_id
FROM   apps.ahl_item_groups_vl
WHERE  item_group_id = :p_item_group_id;

Join to related MRO entities by ITEM_GROUP_ID to build denormalized reporting queries, and supply the correct language context (through the NLS_LANG setting or equivalent) when extracting data so that translated descriptions are returned as expected.