Results for “ahl_rt_oper_labor_v”

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

Overview

In Oracle E-Business Suite, the view AHL_RT_OPER_LABOR_V belongs to the Complex Maintenance, Repair and Overhaul (AHL) product family and is owned by the APPS schema. It combines operational labor data with human-resource code descriptions, exposing the labor requirements recorded against a maintenance routing operation. The view is defined over the base table AHL_RT_OPER_LABOR (referenced through a synonym) and joins two PER objects through synonyms — PER_COMPETENCES and PER_RATING_LEVELS — to translate stored identifier codes into readable descriptions. In the ETRM documentation for 12.2.2, the view is reported as VALID, and the object remains consistent with the 12.1.1 implementation.

The view’s documented purpose is to include all corresponding descriptions of the codes stored in the base labor table, making it suitable for operational reporting, concurrent program extraction, and inbound integration where consumers need readable skill and rating information rather than raw identifiers.

Underlying Base Objects

The documented base objects underlying the view are:

• AHL_RT_OPER_LABOR (synonym) — the primary table holding labor lines tied to a routing operation. Most columns in the view are drawn directly from this table.
• PER_COMPETENCES (synonym) — provides the competence name, aliased as SKILL_NAME in the view.
• PER_RATING_LEVELS (synonym) — supplies rating level detail used to construct SKILL_LEVEL_DESCRIPTION.

The labor table is outer-joined on the rating level (SQL shows the (+) operator on SKILLLEVEL.RATING_LEVEL_ID), so rows without an assigned rating level are retained and expose NULL for the derived description. The join to PER_COMPETENCES is an inner (equi) join on SKILL_COMPETENCE_ID.

Key Columns

• RT_OPER_LABOR_ID — primary key of the labor line.
• OBJECT_ID — identifies the routing operation the labor requirement belongs to.
• SKILL_COMPETENCE_ID / SKILL_NAME — the competence identifier and its decoded name.
• SKILL_RATING_LEVEL_ID / SKILL_LEVEL_DESCRIPTION — the rating level identifier and a derived string combining STEP_VALUE and NAME (e.g. “3-Advanced”).
• ASSOCIATION_TYPE_CODE — code describing how the labor is associated with the operation.
• REVISION_NUMBER, HEADCOUNT, DURATION, TIME_SPAN — planning attributes for the labor requirement.
• SIGN_OFF_FLAG — a flag indicating whether sign-off is required for the labor record; this is the column most frequently targeted by user searches.
• Standard WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — plus OBJECT_VERSION_NUMBER for optimistic locking.

Common Use Cases and Queries

Typical usage includes reporting labor requirements for a routing operation, filtering records that require sign-off, and exposing skill descriptions to downstream systems.

SELECT rt_oper_labor_id, object_id, skill_name,
       skill_level_description, sign_off_flag
FROM   apps.ahl_rt_oper_labor_v
WHERE  sign_off_flag = 'Y';

A second pattern lists labor lines for a specific operation with a readable skill profile:

SELECT v.skill_name, v.skill_level_description,
       v.headcount, v.duration, v.sign_off_flag
FROM   apps.ahl_rt_oper_labor_v v
WHERE  v.object_id = :p_operation_id
ORDER BY v.skill_name;

Because the view supplies the description lookup inline, it is preferred over querying AHL_RT_OPER_LABOR directly in reports, avoiding repeated joins to PER_COMPETENCES and PER_RATING_LEVELS.