Search Results hosted_svc_id




Overview
Explore in AI Chat

Overview

The view AHM_PARTY_SUBSCRIBED_SVC_V belongs to the Oracle E-Business Suite module AHM – Hosting Manager, which is documented in ETRM as Obsolete. Its stated purpose is to return information for all subscribed services associated with a given party ID. In practice, the view exposes a consolidated, query-ready projection of subscription data joined to hosted service definitions, allowing reporting and integration logic to resolve which services a party has subscribed to without navigating the full normalized table structure.

The view is relevant to the search term hosted_svc_id because that column is central to the view's defining query and to its join conditions. The view text joins AHM_SUBSCRIBED_SVCS to AHM_HOSTED_SVCS_VL on HOSTED_SVC_ID, and further restricts results using slot type services and slot allocations. As the module is marked obsolete, customers typically encounter this object in legacy customizations, historical data migrations, or in documentation review rather than in current implementations.

Underlying Base Objects

According to the documented view text, AHM_PARTY_SUBSCRIBED_SVC_V is defined over the following referenced objects:

ETRM notes that no base objects are documented separately and the view is "not implemented in this database," meaning the object may not exist in every environment or release instance. The join structure indicates a deliberately narrowed result set: only hosted services that are active (STATUS = 'A'), flagged for web display (WEB_DISPLAY = 'Y'), and tied to an allocated slot type are returned.

Key Columns

  • PARTY_ID – the trading community or party identifier for which subscribed services are reported.
  • SUBSCRIBED_SVC_ID – the unique identifier of the subscription record in AHM_SUBSCRIBED_SVCS.
  • HOSTED_SVC_ID – the identifier of the hosted service to which the party is subscribed; used as the principal join key across the defining query and its subqueries.
  • HOSTED_SVC_KEY – the user-facing or integration key for the hosted service, sourced from AHM_HOSTED_SVCS_VL.

Supporting filter attributes from the underlying objects — STATUS, WEB_DISPLAY, SLOT_TYPE_ID, and SLOT_ALLOCATION context — govern which rows qualify for inclusion, though they are not projected as visible columns in the documented output.

Common Use Cases and Queries

Typical scenarios include identifying every active subscribed service for a party, resolving a HOSTED_SVC_KEY from a known PARTY_ID, and validating that a subscription maps to a slot-allocation-backed hosted service. Because the view is obsolete, use case references are generally historical or migration-oriented.

Example query for a specific party:

SELECT party_id,
       subscribed_svc_id,
       hosted_svc_id,
       hosted_svc_key
FROM   ahm_party_subscribed_svc_v
WHERE  party_id = :p_party_id;

Example query resolving all web-visible subscriptions by hosted service:

SELECT party_id,
       hosted_svc_id,
       hosted_svc_key
FROM   ahm_party_subscribed_svc_v
ORDER  BY party_id, hosted_svc_id;

Given the obsolete status and the "not implemented" notation, developers should verify object availability before relying on this view and should confirm that current functionality has been superseded by supported Hosting Manager or Trading Community objects.