Search Results current_project_name_number




Overview
Explore in AI Chat

Overview

PA_RESOURCE_AVAIL_STAFF_V is an Oracle E-Business Suite internal view owned by the APPS schema and registered under FND Design Data as PA.PA_RESOURCE_AVAIL_STAFF_V. It is classified with a status of VALID and a view type of Internal, and forms part of the resource availability and staffing model within Oracle Projects (PA). The view consolidates staffing-relevant attributes for project resources—employees and contingent workers—into a single denormalized presentation, exposing identity, organization, reporting hierarchy, geographic location, and current project assignment information.

Because the object is designated Internal, Oracle Corporation does not support direct access to application data through it except from standard Oracle Applications programs. The following warning accompanies the object: "Oracle Internal Use Only — Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs." Consequently, it should be treated as a supporting object for Oracle Projects functionality such as resource search, staffing, and availability analysis rather than a published integration interface. Customers who query it do so at their own risk, since column semantics and definitions may change without notice across releases such as 12.1.1 and 12.2.2.

The column CURRENT_PROJECT_NAME_NUMBER, which matches the user's search term, is a notable output of this view: it returns the project name and project number of the project on which a resource is currently working, concatenated into a single VARCHAR2(4000) value.

Underlying Base Objects

The documented view metadata for release 12.2.2 identifies the following referenced base objects:

The primary staffing data originates from PA_RESOURCES_DENORM, the denormalized resource table that supplies resource identity and assignment attributes. PER_ALL_PEOPLE_F provides person-level details such as full names and dates, while HR_ALL_ORGANIZATION_UNITS_TL supplies the translated organization names associated with primary assignments. The FND_GRANTS, FND_MENUS, and FND_OBJECTS synonyms and the WF_ROLES view relate to function security and workflow role resolution, supporting the view's internal use in menu-driven or role-aware resource availability logic. PA_RESOURCE_UTILS is a PL/SQL package whose functions are invoked from within the view definition to derive calculated attributes.

Key Columns

The view exposes the following significant columns:

Common Use Cases and Queries

Typical scenarios include identifying which project each resource is currently assigned to, locating resources by organization, manager, job level, or geography, and distinguishing employees from contingent workers for staffing and availability analysis. A representative query selecting the requested column is shown below.

SELECT resource_id, resource_name, current_project_id, current_project_name_number FROM apps.pa_resource_avail_staff_v;

To narrow results to a specific project, filter on CURRENT_PROJECT_ID or search the concatenated CURRENT_PROJECT_NAME_NUMBER. Because of the Internal designation, such queries should be confined to diagnostic or reporting purposes, and any reliance on the view should be validated against the specific patch level in use.