Search Results ahl_doc_revision_copies




Overview
Explore in AI Chat

Overview

The AHL_DOC_REVISION_COPIES table is a core data object within the Oracle E-Business Suite (EBS) module for Complex Maintenance, Repair, and Overhaul (AHL). Its primary function is to maintain an audit trail of document distribution by recording the specific individuals or parties who have received copies of a revised document. This table is essential for compliance, traceability, and communication management in maintenance operations, ensuring a verifiable record of who was informed of engineering or procedural changes documented in revisions.

Key Information Stored

The table's structure is designed to link document revisions with recipient parties. The critical columns are the foreign keys that establish these relationships. The DOC_REVISION_COPY_ID column serves as the unique primary key for each recipient record. The DOC_REVISION_ID column is a foreign key that links each record to a specific document revision in the AHL_DOC_REVISIONS_B table. The RECEIVED_BY_PARTY_ID column is a foreign key that identifies the recipient, linking to the HZ_PARTIES table in Oracle's Trading Community Architecture (TCA) model, which stores comprehensive information about persons and organizations.

Common Use Cases and Queries

A primary use case is generating a distribution list report for a specific document revision, often for audit purposes or to verify communication protocols. Support personnel may query this table to identify all parties who received a particular revision or to check if a specific individual was notified. Common SQL patterns include joining to the HZ_PARTIES table to retrieve recipient names and to AHL_DOC_REVISIONS_B for revision details.

  • To list all recipients for a given document revision ID: SELECT hzp.party_name FROM ahl_doc_revision_copies adrc, hz_parties hzp WHERE adrc.received_by_party_id = hzp.party_id AND adrc.doc_revision_id = :p_rev_id;
  • To find all revisions where a specific party was a recipient: SELECT adrc.doc_revision_id FROM ahl_doc_revision_copies adrc WHERE adrc.received_by_party_id = :p_party_id;

Related Objects

The table has defined dependencies on two key EBS objects, as documented by its foreign key constraints. It is fundamentally a child table of AHL_DOC_REVISIONS_B, which stores the header information for document revisions. The relationship is maintained via the DOC_REVISION_ID column. For recipient details, it relies entirely on the HZ_PARTIES table through the RECEIVED_BY_PARTY_ID column. This design centralizes party data management in TCA while allowing the AHL module to track document-specific distribution. There are no other documented foreign keys referencing this table, indicating it is primarily a detail table queried directly or via its parent.