Search Results ahl_supplier_documents_pk

Overview

The AHL_SUPPLIER_DOCUMENTS 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 establish and manage associations between documents and external suppliers or vendors. This table acts as a critical junction, linking the document management system (AHL_DOCUMENTS_B) with the enterprise's supplier master data, which is maintained in both the Trading Community Architecture (HZ_PARTIES) and Purchasing (PO_VENDORS) modules. Its role is to ensure that relevant technical documents, such as maintenance manuals, service bulletins, or part specifications, are correctly attributed to their source suppliers, supporting traceability and compliance in maintenance operations.

Key Information Stored

The table's structure is designed to enforce unique and valid relationships. The key columns are the primary key, SUPPLIER_DOCUMENT_ID, which provides a unique identifier for each supplier-document link. The two critical foreign key columns are DOCUMENT_ID, which references a specific record in AHL_DOCUMENTS_B, and SUPPLIER_ID, which references a supplier party in HZ_PARTIES and potentially a vendor in PO_VENDORS. A unique constraint (AHL_SUPPLIER_DOCUMENTS_UK1) on the combination of SUPPLIER_ID and DOCUMENT_ID prevents duplicate associations from being created for the same supplier and document pair.

Common Use Cases and Queries

This table is essential for queries that retrieve all documents provided by a specific supplier or identify the supplier associated with a particular technical document. Common reporting scenarios include generating a list of all service manuals from a specific aircraft part manufacturer or auditing supplier-provided documentation for compliance. A typical query pattern would join AHL_SUPPLIER_DOCUMENTS with AHL_DOCUMENTS_B and HZ_PARTIES to fetch document details alongside supplier names.

SELECT asd.supplier_document_id,
       hzp.party_name AS supplier_name,
       adoc.document_number,
       adoc.document_title
FROM ahl_supplier_documents asd,
     hz_parties hzp,
     ahl_documents_b adoc
WHERE asd.supplier_id = hzp.party_id
  AND asd.document_id = adoc.document_id
  AND hzp.party_name = '&Supplier_Name';

Related Objects

The table maintains defined foreign key relationships with several master tables, as documented in the ETRM metadata:

• AHL_DOCUMENTS_B: Linked via the DOCUMENT_ID column. This is the core documents table in the AHL module.
• HZ_PARTIES: Linked via the SUPPLIER_ID column. This is the universal registry for parties, including suppliers, within Oracle Trading Community Architecture.
• PO_VENDORS: Also linked via the SUPPLIER_ID column. This provides a direct link to the purchasing-specific vendor information.

The primary key AHL_SUPPLIER_DOCUMENTS_PK (on SUPPLIER_DOCUMENT_ID) ensures each record is uniquely identifiable and can be referenced by other objects or application logic.