Results for “ad_snapshots”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FND_IMP_SSUMMARY_VL is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the FND — Application Object Library product. The view consolidates snapshot metadata into a denormalized, readable form by joining snapshot records to their associated APPL_TOP definitions. Its name follows the standard EBS naming convention: the "FND" prefix denotes the Application Object Library, the "IMP" segment associates it with the import/snapshot infrastructure, and the "_VL" suffix designates a "value list" style validation view, which typically exposes a primary key column alongside a user-facing descriptive name suitable for list-of-values and lookup queries. The object is documented with a status of VALID in ETRM 12.1.1 / 12.2.2, confirming it is a supported, active database object rather than a deprecated artifact.

In practice, the view serves as an integration and reporting surface over the AD snapshot and APPL_TOP configuration data. Administrators, DBAs, and concurrent programs that need to present or resolve snapshots in human-readable terms can query this view instead of writing their own join between the two underlying tables.

Underlying Base Objects

The view is defined over the following documented base objects, both referenced through synonyms in the APPS schema:

• AD_SNAPSHOTS — the primary driving table (aliased X). It stores snapshot header information, including the snapshot identifier, name, type, and associated APPL_TOP identifier.
• AD_APPL_TOPS — the lookup table (aliased Y). It provides the descriptive attributes of an APPL_TOP, namely its name and description.

The join condition is X.APPL_TOP_ID = Y.APPL_TOP_ID(+), an outer join driven from AD_SNAPSHOTS. This design ensures that every snapshot row is returned even when no matching APPL_TOP record exists; in such cases the APPL_TOP_NAME and APPL_TOP_DESC columns return NULL. Because the join is anchored on the snapshot, the view is effectively a snapshot registry enriched with APPL_TOP context.

Key Columns

• SNAPSHOT_ID — the unique identifier of the snapshot; serves as the effective primary key of the view.
• SNAPSHOT_NAME — the user-defined name assigned to the snapshot, providing the human-readable label used in value lists.
• SNAPSHOT_TYPE — the classification of the snapshot, distinguishing the kind of configuration or state captured.
• APPL_TOP_ID — the foreign key linking the snapshot to its APPL_TOP; the column on which the outer join is performed.
• APPL_TOP_NAME — the name of the associated APPL_TOP, sourced from AD_APPL_TOPS.NAME; NULL when no match exists.
• APPL_TOP_DESC — the descriptive text of the associated APPL_TOP, sourced from AD_APPL_TOPS.DESCRIPTION.

Common Use Cases and Queries

The view is typically used when the user search concerns ad_appl_tops, since it presents APPL_TOP names and descriptions alongside the snapshot that owns them. A common scenario is resolving a snapshot identifier to a friendly label, or listing all snapshots for a given APPL_TOP. The following query retrieves snapshot and APPL_TOP details:

• SELECT snapshot_id, snapshot_name, snapshot_type, appl_top_id, appl_top_name, appl_top_desc FROM apps.fnd_imp_ssummary_vl;
• SELECT snapshot_name, appl_top_name FROM apps.fnd_imp_ssummary_vl WHERE appl_top_id = :p_appl_top_id;
• SELECT snapshot_name, snapshot_type FROM apps.fnd_imp_ssummary_vl WHERE appl_top_name IS NULL; — identifies orphaned snapshots with no matching APPL_TOP.

These patterns support diagnostics, snapshot inventory reporting, and list-of-values definitions that rely on the "_VL" contract of exposing an ID and a descriptive name.