Search Results resolution_description




Overview
Explore in AI Chat

Overview

PA_CI_BASIC_CTL_V is a reporting view owned by the APPS schema within the Oracle Projects (PA) module. It presents a consolidated, denormalized representation of project control items — the issues, action items, change requests, and similar tracked items that flow through Oracle Projects' control item framework. The view joins PA_CONTROL_ITEMS to project, status, party, currency, lookup, and control-item type data so that a single query returns both the control item attributes and their decoded descriptive values.

Because it resides in the APPS schema and is marked VALID, the view is available for ad hoc reporting, Oracle Business Intelligence Publisher data models, custom concurrent programs, and interface extraction routines. It is one of several "BASIC" control-item views that expose the core control item record without the business logic wrapping found in the corresponding utility package. Note that the object metadata supplied for this view documents a locked_flag search term; the view's visible column list does not itself expose a LOCKED_FLAG column, so any "locked" semantics encountered by users typically originate from the control item status, the CLOSEALLOWED/DELETEALLOWED helper functions, or from other control item views in the same family.

Underlying Base Objects

The documented base objects for PA_CI_BASIC_CTL_V are:

  • PA_CONTROL_ITEMS (synonym) — the primary table supplying the control item record, aliased as CI.
  • PA_PROJECTS_ALL (synonym) — project-level attributes such as segment1, name, status code, and start date, aliased as PPA.
  • PA_PROJECT_STATUSES (synonym) — status name and system status code used to drive the status icons and close/delete rules, aliased as STATUS and PPS.
  • PA_CI_TYPES_VL (view) — the control item type definition, providing class code, short name, and the approval/auto-number/resolution/source flag set, aliased as CITYPE.
  • PA_CLASS_CODES (synonym) — class codes for resolution, classification, and reason, aliased as RESOLUTION, CLASSIFICATION, and REASON respectively.
  • PA_LOOKUPS (view) — meaning values for priority, source, and effort level, aliased as PRIORITY_LKP, SOURCE_LKP, and EFFORT_LKP.
  • HZ_PARTIES (synonym) — party names for owner, closed-by, and last-modified-by, aliased as OWNER, CLOSED_BY, and MODIFIED_BY.
  • FND_CURRENCIES_TL (synonym) — currency description for the price currency code, aliased as CURRENCY.
  • PA_CONTROL_ITEMS_UTILS (package) — supplies GETUSERNAME, GET_OBJECT_NAME, CLOSEALLOWED, and DELETEALLOWED.

Each row of the view corresponds to one control item joined to its parent project and its decoded reference data.

Key Columns

Common Use Cases and Queries

Typical uses include control item registers, aging and priority dashboards, owner workload analysis, and feeds into external issue-tracking systems. A simple query follows:

SELECT PROJECT_ID, SEGMENT1, CI_NUMBER, SUMMARY,
       PROJECT_STATUS_NAME, PRIORITY_LKP.MEANING  -- use the aliased expression in your query
FROM   APPS.PA_CI_BASIC_CTL_V
WHERE  OWNER_ID = :p_owner_id
AND    DATE_CLOSED IS NULL;

Because decoded meanings are exposed as expressions rather than named columns, most reports alias them explicitly (for example, PRIORITY_LKP.MEANING priority_meaning) in a wrapping inline view. Filtering on PROJECT_ID and STATUS_CODE yields efficient, project-scoped control item lists for embedded dashboards and concurrent extracts.