Search Results classification_description




Overview
Explore in AI Chat

Overview

APPS.PA_RELATED_ITEMS_V is a seeded Oracle Projects view that presents a consolidated, security-filtered listing of control items ("related items") associated with a project. Within Oracle EBS 12.1.1 and 12.2.2, control items represent project-related records that require tracking through a controlled lifecycle — for example, change requests, issues, deliverables, action items, and other controlled entities defined by the project's control item types. The view joins project data, control item data, control item type definitions, owner party information, status codes, and classification/reason lookups into a single denormalized result set.

The view is designated Oracle Internal Use Only in the ETRM documentation. Oracle Corporation does not support direct access to applications data through this object except from standard Oracle Applications programs. In practice it is surfaced through Oracle Projects forms, HTML-based pages, and Oracle Business Intelligence/XML Publisher reports that list related items for a project. Its status is VALID, and the underlying FND design data is registered as PA.PA_RELATED_ITEMS_V.

Underlying Base Objects

The ETRM dependency listing documents that PA_RELATED_ITEMS_V references the following objects:

The view is not referenced by any other database object, confirming its role as a reporting endpoint rather than a building block for further dependent views.

Key Columns

  • PROJECT_ID / PROJECT_NAME_NUMBER — the owning project and its concatenated name/number identifier.
  • CI_ID / CI_NUMBER / SUMMARY — the control item identifier, user-visible number, and descriptive summary.
  • CI_TYPE_ID / CI_TYPE_NAME / CI_TYPE_SHORT_NAME / CI_TYPE_NUMBER — the control item type designation. CI_TYPE_NUMBER is the column most commonly targeted when users search on "ci_type_number"; it is a VARCHAR2(132) attribute carrying the type's numeric or coded identifier.
  • CI_TYPE_CLASS_CODE — class of the control item type.
  • STATUS_CODE / STATUS_DESCRIPTION / SYSTEM_STATUS_CODE — workflow-facing status values and their descriptive equivalents.
  • OWNER_ID / OWNER_NAME — the party or resource responsible for the control item.
  • OBJECT_TYPE / OBJECT_ID / OBJECT_NAME — the parent or related object the control item is linked to.
  • CLASSIFICATION_DESCRIPTION / REASON_DESCRIPTION — decoded lookup values from PA_CLASS_CODES.
  • RECORD_VERSION_NUMBER — optimistic locking/versioning attribute.

Common Use Cases and Queries

Typical usage includes project manager dashboards listing open control items, integration extracts feeding external issue-tracking systems, and ad hoc reporting to locate a control item by its type number. A representative query filtering on ci_type_number is:

SELECT project_name_number
     , ci_number
     , ci_type_name
     , ci_type_number
     , summary
     , status_description
     , owner_name
  FROM apps.pa_related_items_v
 WHERE ci_type_number = :p_ci_type_number
   AND project_id      = :p_project_id;

A broader project-level listing can be produced with:

SELECT ci_number
     , ci_type_short_name
     , ci_type_number
     , summary
     , status_description
     , object_name
     , record_version_number
  FROM apps.pa_related_items_v
 WHERE project_id = :p_project_id
 ORDER BY ci_type_number, ci_number;

Because security filtering is applied through PA_CI_SECURITY_PKG, results are automatically restricted to the control items the querying user is permitted to see. Access should be limited to supported Oracle Applications programs.