Results for “ahl_pc_associations_v”

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

Overview

AHL_PC_ASSOCIATIONS_V is a read-only reporting view in the APPS schema belonging to the AHL (Complex Maintenance Repair and Overhaul) product family in Oracle EBS 12.1.1 and 12.2.2. The view presents the association between an item or a tracked unit instance and a Physical Configuration (PC) node, expanding the base table AHL_PC_ASSOCIATIONS into a denormalized, user-friendly projection. The central purpose of the view is to resolve internal identifier values into descriptive, human-readable attributes — most notably the concatenated item number and the unit name — so that PC structures can be queried without additional joins to inventory master data. Users frequently reference the column UNIT_ITEM_NAME, which returns the displayed name of the associated unit or item depending on the row's association type.

Underlying Base Objects

The ETRM 12.2.2 metadata documents the following referenced base objects: AHL_PC_ASSOCIATIONS, AHL_PC_HEADERS_B, AHL_PC_NODES_B, AHL_UNIT_CONFIG_HEADERS, CSI_ITEM_INSTANCES, and MTL_SYSTEM_ITEMS_KFV. The view text confirms that AHL_PC_ASSOCIATIONS (aliased AHS) is the primary driver, supplying PC node links, association flags, and the descriptive flexfield attribute columns. MTL_SYSTEM_ITEMS_KFV supplies item-level data via CONCATENATED_SEGMENTS and DESCRIPTION. CSI_ITEM_INSTANCES contributes serial number information for serialized unit instances. AHL_PC_NODES_B and AHL_PC_HEADERS_B provide the PC tree hierarchy, while AHL_UNIT_CONFIG_HEADERS supports the unit configuration context. All referenced objects are synonyms resolving to their underlying tables in the APPS or product schema.

Key Columns

• PC_ASSOCIATION_ID — primary key of the association record.
• PC_NODE_ID — the physical configuration node to which the item or unit is attached.
• UNIT_ITEM_ID — internal identifier of the associated item or unit instance.
• UNIT_ITEM_NAME — for item associations, the concatenated item segments; for unit associations, the unit name. This is the column most commonly searched by users.
• UNIT_ITEM_DESCRIPTION — description from the item master.
• ASSOCIATION_TYPE_FLAG — indicates whether the row represents an item ('I') or a unit association; the UNION in the view text branches on this flag.
• SERIAL_NUMBER — populated for serialized unit associations and blank for item associations.
• ITEM_NUMBER — concatenated segments of the underlying item, useful for reporting on product identity.
• PRODUCT_TYPE — item type classification from MTL_SYSTEM_ITEMS_KFV.
• INVENTORY_ORG_ID and OPERATION_STATUS_FLAG — inventory context and lifecycle status of the association.
• ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield segments carried from the base association table.

Common Use Cases and Queries

The view is typically used to report which units or items are configured at each PC node, to trace serialized instances against a product structure, and to drive maintenance execution screens. A basic query to locate a unit by the name the user typed:

• SELECT pc_node_id, unit_item_id, unit_item_name, unit_item_description, serial_number, association_type_flag FROM ahl_pc_associations_v WHERE unit_item_name LIKE :bind_name;
• Filtering to serialized units only: SELECT pc_node_id, unit_item_name, serial_number FROM ahl_pc_associations_v WHERE association_type_flag = 'U';
• Joining to the PC node hierarchy for a full path report: SELECT v.unit_item_name, h.pc_header_name, n.pc_node_name FROM ahl_pc_associations_v v, ahl_pc_nodes_b n, ahl_pc_headers_b h WHERE v.pc_node_id = n.pc_node_id AND n.pc_header_id = h.pc_header_id;

Because the view carries no ORG_ID filter of its own beyond the union's item branch, reports should apply the appropriate organization context through the input parameters of the query.