Search Results ahl_stage_links

Overview

AHL_STAGE_LINKS is a table owned by the AHL schema within Oracle E-Business Suite, belonging to the Complex Maintenance Repair and Overhaul (AHL) product module. In EBS 12.1.1 and 12.2.2, the AHL module supports the maintenance, repair, and overhaul of complex assets, and tables in this schema typically store configuration, routing, and staging data used by the maintenance engineering and execution processes. AHL_STAGE_LINKS acts as a relationship or association table that links a staging object to a subject entity, expressed through the OBJECT_ID and SUBJECT_ID columns plus a RELATION_TYPE qualifier.

Following a heuristic Data Vault classification derived from the foreign key structure, AHL_STAGE_LINKS is best modeled as a standalone table, though its pair of foreign keys (SUBJECT_ID and OBJECT_ID-style relationships) suggest it can also behave as a link table resolving a many-to-many association between subjects and their related objects. The table is physically registered with 27 columns and a single unique index, AHL_STAGE_LINKS_U1, defined on STAGE_LINK_ID.

Key Information Stored

The table is anchored by STAGE_LINK_ID, a surrogate primary key enforced through the unique index AHL_STAGE_LINKS_U1. This is the only documented business-key candidate; the remaining columns are descriptive or referential.

• STAGE_LINK_ID — surrogate primary key uniquely identifying each link row.
• OBJECT_ID — identifier of the staging or source object participating in the relationship.
• SUBJECT_ID — foreign key referencing IGS_UC_COM_EBL_SUBJ; identifies the subject entity to which the object is linked.
• RELATION_TYPE — classifies the nature of the link between the object and subject.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, driving row-level access control.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF/BC4J framework.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS WHO columns auditing creation and modification.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield (DFF) context and segment columns for client-specific extensions.

Common Use Cases and Queries

AHL_STAGE_LINKS is typically queried to resolve the relationships a staging object holds with subjects. A basic lookup retrieves all links for a given subject:

• SELECT stage_link_id, object_id, relation_type FROM ahl.ahl_stage_links WHERE subject_id = :p_subject_id;
• Joining to FND_SECURITY_GROUPS for access-filtered reporting:
• SELECT l.stage_link_id, l.relation_type, g.security_group_name FROM ahl.ahl_stage_links l, fnd_security_groups g WHERE l.security_group_id = g.security_group_id;
• DFF extraction using the ATTRIBUTE_CATEGORY / ATTRIBUTE* pattern for extension reporting.
• Audit queries filtering on LAST_UPDATE_DATE to identify recent maintenance of link records.

Reporting use cases include dependency mapping between staging objects and their subjects, security-scoped access validation, and integration extracts where AHL stage relationships feed external maintenance planning systems.

Related Objects

• IGS_UC_COM_EBL_SUBJ — referenced by SUBJECT_ID; the parent subject entity for each link.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID; controls row-level security.
• AHL_STAGE_LINKS_U1 — the unique index on STAGE_LINK_ID enforcing the primary key.
• FND_USER — implicit dependency via CREATED_BY and LAST_UPDATED_BY WHO columns.
• FND_APPLICATION / FND_OBJECTS — supporting metadata used where RELATION_TYPE and OBJECT_ID resolve against registered EBS objects.

Because the documentation classifies this table as standalone, direct dependent child tables are not enumerated; most interaction occurs through the two foreign keys and the standard EBS flexfield and audit infrastructure.