Results for “project_status”

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

Overview

PA_PURGE_PROJECTS_LOV_V is a Projects (PA) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It supplies the list of values used by the Project Purge process, exposing the projects that an operator is permitted to select for purge. The view joins project definition data with status and organization descriptions so the purge LOV can display human-readable identification. Notably, it filters on PA_SECURITY.ALLOW_UPDATE, meaning the rows returned are restricted to projects the current user is authorized to update; this enforces the security model within the purge workflow.

Underlying Base Objects

The view text is defined over PA_PROJECTS, PA_PROJECT_STATUSES, and HR_ORGANIZATION_UNITS. In the documented ETRM metadata, PA_PROJECTS and PA_PROJECT_STATUSES are referenced as synonyms (owned by APPS), HR_ORGANIZATION_UNITS is a view, and PA_SECURITY is a package invoked in the WHERE clause. HR_GENERAL and HR_SECURITY packages are also listed as referenced base objects, supporting the organization/security resolution used internally. The join relationships are: PA_PROJECTS.CARRYING_OUT_ORGANIZATION_ID equals HR_ORGANIZATION_UNITS.ORGANIZATION_ID (aliased O1), and PA_PROJECTS.PROJECT_STATUS_CODE equals PA_PROJECT_STATUSES.PROJECT_STATUS_CODE. The filter P.TEMPLATE_FLAG <> 'Y' removes project templates, and PA_SECURITY.ALLOW_UPDATE(P.PROJECT_ID) = 'Y' restricts rows to update-authorized projects.

Key Columns

• PROJECT_NUMBER — maps to PA_PROJECTS.SEGMENT1, the user-visible project number.
• PROJECT_NAME — the project name (PA_PROJECTS.NAME).
• PROJECT_ID — the internal unique project identifier used by the security function and purge logic.
• ORGANIZATION_NAME — the name of the carrying-out organization from HR_ORGANIZATION_UNITS.
• ORGANIZATION_ID — the carrying-out organization identifier (PA_PROJECTS.CARRYING_OUT_ORGANIZATION_ID).
• PROJECT_STATUS_CODE — the status code of the project.
• PROJECT_STATUS — the descriptive status name from PA_PROJECT_STATUSES.PROJECT_STATUS_NAME.
• PROJECT_CLOSED_DATE — the status close date for the project (PA_PROJECTS.CLOSED_DATE). This is the column most relevant to users searching for project_closed_date, providing the date the project was closed.
• PROJECT_TYPE — the classification of the project (e.g., contract, indirect).
• ORG_ID — the operating unit identifier, supporting multi-org filtering.

Common Use Cases and Queries

The primary use is populating the Project Purge LOV, but it is also useful for querying closed projects and their closing dates. A typical query lists closed projects within an operating unit:

SELECT project_number,
       project_name,
       project_status,
       project_closed_date
FROM   apps.pa_purge_projects_lov_v
WHERE  org_id = :p_org_id
AND    closed_date ... ;

Because the view applies PA_SECURITY.ALLOW_UPDATE, results vary by user responsibility, making it appropriate for purge candidate identification and audit reporting of closed projects. Organizations also use it to reconcile the project_closed_date for purge eligibility checks before initiating the actual purge concurrent program.