Results for “project_status_name”

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

Overview

PA_PLM_PROJECTS_V is a read-only Oracle EBS view owned by the APPS schema in the Projects (PA) module. Its name reflects its primary purpose within the Product Lifecycle Management (PLM) integration: it exposes a consolidated, security-filtered list of non-template projects together with their current status, progress reporting indicators, and the identity of the party holding project role 1 (typically the project manager). The view is registered as a VALID object in both Oracle EBS 12.1.1 and 12.2.2, and its columns and underlying objects are consistent across those releases as documented in ETRM metadata.

Because the view embeds PA_PROJECTS_SEC_V rather than PA_PROJECTS_ALL directly, all rows returned are automatically constrained by Oracle Projects security. The inclusion of FND_GLOBAL via the security view means that queries executed through this object respect the responsibility-level and user-level access rules defined in PA_SECURITY_PVT, which is referenced by the security view. This makes PA_PLM_PROJECTS_V suitable for reporting and integration consumers that must not expose projects outside the caller's authorized scope.

Underlying Base Objects

The view is defined over five principal sources, joined with the outer-join syntax characteristic of earlier EBS development standards.

• PA_PROJECTS_SEC_V (PPA) — the security-filtered project master. Supplies project identity, name, long name, segment, type, carrying-out organization, status code, description, template flag, operating unit (ORG_ID), and project currency code.
• PA_PROJECT_STATUSES (PPS) — lookup of project status codes and their translated status names; joined on PROJECT_STATUS_CODE.
• PA_PROJECT_PARTIES (PARTIES) — outer-joined with PROJECT_ROLE_ID = 1 and an effective-dated window (START_DATE_ACTIVE through NVL(END_DATE_ACTIVE, SYSDATE+1)) to isolate the party in the primary role.
• PER_ALL_PEOPLE_F (PEOPLE) — outer-joined on RESOURCE_SOURCE_ID = PERSON_ID within the person's effective date range, providing the party's full name.
• PA_PROJ_CURR_STATUS_REP_V (PR) — the current status reporting view, outer-joined on PROJECT_ID, supplying progress status code/name and the status icon flags.

The view additionally depends on FND_GLOBAL and PA_SECURITY_PVT through PA_PROJECTS_SEC_V. Note that PA_PROJECTS_SEC_V exposes PERSON_ID and PERSON_NAME in the column list metadata, while the underlying select aliases PEOPLE.FULL_NAME along the PARTIES join; these are the party-derived columns surfaced to consumers.

Key Columns

• PROJECT_ID / NAME / LONG_NAME / SEGMENT1 — the project's primary key, short name, long name, and project number.
• PROJECT_TYPE / CARRYING_OUT_ORGANIZATION_ID / ORG_ID — classification, owning organization, and operating unit.
• PROJECT_STATUS_CODE / PROJECT_STATUS_NAME — the system status code and its descriptive name.
• TEMPLATE_FLAG — always 'N' in this view; template projects are filtered out entirely.
• PROJECT_CURRENCY_CODE — the project's functional currency.
• PERSON_ID / PERSON_NAME — the resource and name of the party holding project role 1 (project manager role), subject to effective dating.
• PROGRESS_STATUS_CODE / PROGRESS_STATUS_NAME — the current progress status from the status reporting view.
• PROGRESS_ICON / PROGRESS_ICON_ACTIVE — status indicators used by PLM and project-status UI components to render visual flags.

Common Use Cases and Queries

The view is most commonly used by PLM and project-portfolio integrations that need a compact, security-aware project list with manager and progress attributes, without joining the underlying tables themselves. Typical query patterns include:

• Listing all accessible non-template projects with their managers:

  SELECT project_id, name, person_name, project_status_name
  FROM   pa_plm_projects_v
  ORDER BY name;

• Filtering by operating unit and status for a PLM push:

  SELECT segment1, long_name, progress_status_name
  FROM   pa_plm_projects_v
  WHERE  org_id = :p_org_id
  AND    project_status_code = 'APPROVED';

• Retrieving progress indicators for dashboard rendering:

  SELECT project_id, progress_icon, progress_icon_active
  FROM   pa_plm_projects_v
  WHERE  progress_status_code IS NOT NULL;

Because security is enforced inside PA_PROJECTS_SEC_V, no additional access predicates are required; results are automatically limited to the projects the executing user is permitted to see.