Search Results ahl_subscriptions_b




Overview
Explore in AI Chat

Overview

The AHL_SUBSCRIPTIONS_B table is a core data object within the Oracle E-Business Suite (EBS) module for Complex Maintenance, Repair, and Overhaul (CMRO). It serves as the primary transactional repository for managing subscriptions to documents. In the context of asset-intensive industries like aviation and manufacturing, this table facilitates the formal process by which parties request and receive specific technical or operational documents, ensuring controlled distribution and compliance. Its role is integral to the document management workflow within the AHL module, linking document masters with trading community entities.

Key Information Stored

The table's structure centers on identifying the document, the subscribing party, and the source party. The primary key, SUBSCRIPTION_ID, uniquely identifies each subscription record. The critical foreign key columns define the core relationships: DOCUMENT_ID references the specific document in AHL_DOCUMENTS_B, REQUESTED_BY_PARTY_ID identifies the party (from HZ_PARTIES) who is subscribing, and SUBSCRIBED_FROM_PARTY_ID identifies the party from whom the document is being sourced or obtained. Additional columns, not fully detailed in the metadata but typical for such transactional tables, would likely include creation dates, last update dates, status flags, and effective date ranges to manage the subscription lifecycle.

Common Use Cases and Queries

Primary use cases involve reporting on document distribution and managing subscription requests. Common operational queries include identifying all active subscriptions for a specific document to manage revisions, or listing all documents a particular customer party has subscribed to for audit or support purposes. A typical reporting query would join to the translated descriptive table (AHL_SUBSCRIPTIONS_TL) and party tables to present meaningful information.

  • Sample Query (Subscriptions for a Document):
    SELECT s.SUBSCRIPTION_ID, hz1.PARTY_NAME REQUESTED_BY, hz2.PARTY_NAME SUBSCRIBED_FROM
    FROM AHL_SUBSCRIPTIONS_B s,
    HZ_PARTIES hz1,
    HZ_PARTIES hz2
    WHERE s.DOCUMENT_ID = :p_document_id
    AND s.REQUESTED_BY_PARTY_ID = hz1.PARTY_ID
    AND s.SUBSCRIBED_FROM_PARTY_ID = hz2.PARTY_ID;

Related Objects

The table maintains defined relationships with several key EBS objects, as documented in the provided metadata.

  • Referenced Foreign Keys (This table references):
    • AHL_DOCUMENTS_B: Via DOCUMENT_ID. This links the subscription to the master document record.
    • HZ_PARTIES (twice): Via REQUESTED_BY_PARTY_ID and SUBSCRIBED_FROM_PARTY_ID. These links integrate with the Trading Community Architecture to identify the involved customer or supplier entities.
  • Referencing Foreign Key (Tables that depend on this table):
    • AHL_SUBSCRIPTIONS_TL: Via SUBSCRIPTION_ID. This is the corresponding translation table that holds language-specific descriptive information for the subscription, following standard EBS multi-language architecture.