Search Results subscribed_svc_id




Overview
Explore in AI Chat

Overview

AHM_HOSTED_SVC_SI_V is a database view defined within the Oracle E-Business Suite (EBS) module AHM — Hosting Manager. It belongs to the Hosting Manager product family, which is classified as obsolete in EBS 12.1.1 and 12.2.2. The view is a thin join construct rather than a business entity in its own right. Its purpose is to correlate three hosting-related base tables so that a hosted service identifier can be resolved into the two surrogate keys that downstream hosting logic consumes: a subscription item map identifier and a subscribed service identifier.

In reporting and integration contexts, the view acts as a convenience mapping layer. Because the AHM schema stores hosted services, subscriptions, and subscription-to-item mappings in three separate tables keyed by HOSTED_SVC_ID, any consumer that needs to move from a hosted service to the subscription item mapping or the subscribed service must perform the same three-way join. AHM_HOSTED_SVC_SI_V encapsulates that join, providing a stable projection for queries and concurrent programs that only require the two derived keys.

It is important to note the metadata state: the ETRM documentation records the view as "Not implemented in this database." This indicates that in the documented environment the view definition exists in the ETRM repository but the database object is not physically present. Consumers should verify existence via ALL_VIEWS or DBA_VIEWS before depending on it.

Underlying Base Objects

The view text is documented explicitly. It is defined over three AHM base tables:

The join condition is identical on both sides: AHS.HOSTED_SVC_ID = ASS.HOSTED_SVC_ID and AHS.HOSTED_SVC_ID = ASIM.HOSTED_SVC_ID. Consequently, AHM_HOSTED_SVCS_B is the driving table, and the view returns one row for every combination of subscribed service and subscription item mapping that shares the same hosted service. The ETRM metadata lists no additional referenced base objects, and the view contains no aggregation, filter predicate, or outer join.

Key Columns

The view exposes exactly two columns:

  • SUBSCRIPTION_ITEM_MAP_ID — sourced from AHM_SUBSCRIPTION_ITEMS_MAP. It is the primary key of the subscription item mapping record and identifies the mapping between a subscription and the items it covers.
  • SUBSCRIBED_SVC_ID — sourced from AHM_SUBSCRIBED_SVCS. It is the primary key of the subscribed service record and is the value most commonly referenced when resolving a service subscription.

Both columns are surrogate identifiers. The HOSTED_SVC_ID used for joining is not projected, so callers that need it must join back to a base table or use the parent queries directly.

Common Use Cases and Queries

The view supports resolution of subscription identifiers from hosted services and cross-referencing of subscribed services with their item mappings.

  • Returning all subscription item maps for a subscribed service.
  • Enumerating subscribed services for a given hosted service by joining to AHM_SUBSCRIBED_SVCS.
  • Feeding downstream hosting integrations that expect (SUBSCRIPTION_ITEM_MAP_ID, SUBSCRIBED_SVC_ID) pairs.

Representative SQL:

  • SELECT SUBSCRIBED_SVC_ID, SUBSCRIPTION_ITEM_MAP_ID FROM AHM_HOSTED_SVC_SI_V WHERE SUBSCRIBED_SVC_ID = :p_subscribed_svc_id;
  • SELECT V.SUBSCRIBED_SVC_ID, V.SUBSCRIPTION_ITEM_MAP_ID FROM AHM_HOSTED_SVC_SI_V V WHERE EXISTS (SELECT 1 FROM AHM_HOSTED_SVCS_B B WHERE B.HOSTED_SVC_ID = :p_hosted_svc_id);

Because the view is documented as not implemented, and because AHM Hosting Manager is obsolete, these queries should be treated as reference patterns. Functional alternatives in the supported hosting or subscription schemas are preferable for new development.