Search Results progress_icon_active




Overview
Explore in AI Chat

Overview

APPS.PA_PLM_PROJECTS_V is a VALID database view owned by the APPS schema within Oracle E-Business Suite (documented across 12.1.1 and 12.2.2). It is classified with the notation "Oracle Internal Use Only," indicating that Oracle Corporation does not support direct access to application data through this object except from standard Oracle Applications programs. The view serves the Oracle Projects (PA) module, specifically the PLM (Project Lifecycle Management / project list) presentation layer, exposing a flattened, security-aware projection of project header information.

Its primary role is to supply project lists and related display attributes to Oracle Projects user interfaces and dependent programs, including status-driven visual indicators used to render project progress. Because the view embeds security logic, it is a convenient reporting source for project data that already honors the caller's access privileges and current project status. The view type is Internal, meaning it is not part of a public, supported API surface.

Underlying Base Objects

Per the documented ETRM metadata, PA_PLM_PROJECTS_V is defined over the following referenced objects:

  • FND_GLOBAL (PACKAGE) — supplies session context such as user ID, responsibility, and organization, which drives row-level security.
  • PA_PROJECTS_SEC_V (VIEW) — the security-filtered project view, providing the secured project population.
  • PA_PROJECT_PARTIES (SYNONYM) — project party/role assignments, used to resolve person details.
  • PA_PROJECT_STATUSES (SYNONYM) — status code translations for project and progress status names.
  • PA_PROJ_CURR_STATUS_REP_V (VIEW) — current project status representation, supplying status and progress attributes.
  • PA_SECURITY_PVT (PACKAGE) — the private security package enforcing project access rules.
  • PER_ALL_PEOPLE_F (SYNONYM) — the HR people table, providing person name resolution for project ownership.

The view is not referenced by any other database object, confirming it is a terminal presentation/reporting layer rather than a building block for further views.

Key Columns

PA_PLM_PROJECTS_V exposes the following columns (datatypes and lengths as documented):

  • PROJECT_ID (NUMBER, 15) — unique project identifier.
  • NAME (VARCHAR2, 30) and LONG_NAME (VARCHAR2, 240) — short and long project names.
  • SEGMENT1 (VARCHAR2, 25) — project number.
  • PROJECT_TYPE (VARCHAR2, 20) — classification of the project.
  • CARRYING_OUT_ORGANIZATION_ID (NUMBER, 15) — the organization executing the project.
  • PROJECT_STATUS_CODE (VARCHAR2, 30) and PROJECT_STATUS_NAME (VARCHAR2, 80) — project status in code and translated form.
  • DESCRIPTION (VARCHAR2, 250) — project description.
  • TEMPLATE_FLAG (VARCHAR2) — indicates whether the record is a project template.
  • ORG_ID (NUMBER, 15) — operating unit identifier.
  • PROJECT_CURRENCY_CODE (VARCHAR2, 15) — project currency.
  • PERSON_ID (NUMBER, 15) and PERSON_NAME (VARCHAR2, 240) — project manager/owner identity.
  • PROGRESS_STATUS_CODE (VARCHAR2, 30) and PROGRESS_STATUS_NAME (VARCHAR2, 80) — progress status in code and translated form.
  • PROGRESS_ICON (VARCHAR2, 80) and PROGRESS_ICON_ACTIVE (VARCHAR2, 80) — icon references used to render the project's progress visually, in inactive and active forms respectively. These columns are the direct basis for the "progress_icon" search term.

Common Use Cases and Queries

Typical uses include building project status dashboards, rendering project lists with progress icons, and extracting secured project metadata for integration. Because the view is internal and unsupported for direct access, queries should be treated as read-only diagnostic or reporting aids.

Retrieve active projects with their progress indicators:

  • SELECT project_id, name, segment1, project_status_name, progress_status_name, progress_icon, progress_icon_active FROM apps.pa_plm_projects_v WHERE template_flag = 'N';

Filter to projects by carrying-out organization and manager:

  • SELECT segment1, long_name, person_name, progress_icon FROM apps.pa_plm_projects_v WHERE carrying_out_organization_id = :org_id AND org_id = :org_id_operating_unit;

Because security is applied through PA_PROJECTS_SEC_V and PA_SECURITY_PVT using FND_GLOBAL context, results are automatically restricted to projects the session user is authorized to see. Consumers should always set the correct FND_GLOBAL session context before querying.