Search Results pa_struct_versions_lov_amg_v




Overview
Explore in AI Chat

Overview

PA_STRUCT_VERSIONS_LOV_AMG_V is an Oracle EBS Projects (PA) schema view owned by the APPS schema and documented as VALID in ETRM 12.2.2 (compatible with 12.1.1). Its stated purpose is to provide a list of structure versions suitable for use as a List of Values (LOV) source. The "AMG" naming convention identifies it as a generated or maintained view commonly used by Oracle Application Framework and related UI components that require a concise, restricted query set for version selection.

The view consolidates identifying, descriptive, and status attributes of project element structure versions and joins them to structure type definitions and lookup meanings. Its principal role is to surface a flat, join-ready result set for version selection in Projects forms, self-service pages, and reporting integrations, avoiding the need for consumers to reproduce the four-way join themselves.

The metadata specifically documents the column LATEST_EFF_PUBLISHED_FLAG, which is relevant because users frequently search for that token. It is the view's indicator of whether a given structure version is the latest effectively published version, enabling filters that return only the current published baseline.

Underlying Base Objects

ETRM documentation records the following referenced base objects: PA_LOOKUPS (VIEW), PA_PROJ_ELEM_VER_STRUCTURE (SYNONYM), PA_PROJ_STRUCTURE_TYPES (SYNONYM), and PA_STRUCTURE_TYPES (SYNONYM).

The view text exposes the join path. PA_PROJ_ELEM_VER_STRUCTURE (aliased PEVS) is the driving object, holding the actual structure version rows. PA_PROJ_STRUCTURE_TYPES (PST) maps a project element to its structure type, while PA_STRUCTURE_TYPES (ST) supplies the structure type definition, including STRUCTURE_TYPE_CLASS_CODE. PA_LOOKUPS (LKP) resolves the class code to a user-facing MEANING using LOOKUP_TYPE = 'PA_STRUCTURE_TYPE_CLASS'.

The result set is a four-object equijoin. Because PA_PROJ_ELEM_VER_STRUCTURE, PA_PROJ_STRUCTURE_TYPES, and PA_STRUCTURE_TYPES are exposed as synonyms, the underlying implementation objects are the PA base tables of the same names. All relational access flows through the APPS schema, consistent with standard Oracle EBS security and synonym conventions.

Key Columns

The view projects the following columns, with documented aliases:

Common Use Cases and Queries

The dominant use case is populating an LOV with structure versions for a selected project, and isolating only the current published version using LATEST_EFF_PUBLISHED_FLAG.

  • List all versions for a project, decoded by type and status.
  • Return only the latest effectively published version for integration or baseline reporting.
  • Cross-check version status against structure type class for validation.

Sample SQL:

SELECT structure_version_id
     , structure_version_name
     , structure_version_number
     , structure_type
     , status_code
     , latest_eff_published_flag
  FROM apps.pa_struct_versions_lov_amg_v
 WHERE project_id = :p_project_id
   AND NVL(latest_eff_published_flag,'N') = 'Y'
 ORDER BY structure_version_number;

For a full version history, remove the latest-effective predicate. Consumers should note that the flag resides on the underlying PA_PROJ_ELEM_VER_STRUCTURE row and reflects publication state maintained by Projects processing.