Search Results resource_last_name




Overview
Explore in AI Chat

Overview

PA_C_ELIG_RESOURCE_V is an Oracle E-Business Suite view owned by the APPS schema and shipped as part of the Oracle Projects (PA) product family. As its description states, the view identifies all resources that are available for use at this time or in the future. In practice it exposes the pool of people who can be selected as project resources—typically for assignment to project teams, expenditure entry, or resource searches within the Projects application and any downstream reporting that consumes the same pool.

The view is read-only and carries a status of VALID. It does not store data itself; it projects a filtered, denormalized result set assembled from Human Resources and Projects tables. Because the majority of the joins are outer joins to Projects-specific tables (PA_RESOURCES, PA_RESOURCE_TYPES, PA_RESOURCE_TXN_ATTRIBUTES), the view surfaces people who satisfy HR employment and assignment criteria even where a Projects resource record has not yet been fully established.

Underlying Base Objects

The view text joins the following documented base objects:

  • PER_PEOPLE_F and PER_ASSIGNMENTS_F (views) — the person and assignment datable sources; the view requires a primary assignment with an assignment type of E (employee) or C (contingent worker) and a non-null JOB_ID.
  • PER_ASSIGNMENT_STATUS_TYPES — restricts results to assignment system statuses ACTIVE_ASSIGN and ACTIVE_CWK.
  • PER_JOB_EXTRA_INFO — requires the job extra information category JOB CATEGORY with JEI_INFORMATION6 equal to Y, effectively flagging jobs eligible for project resource use.
  • PA_ALL_ORGANIZATIONS — the assignment organization must exist with an organization use type of EXPENDITURES and no inactive date.
  • PA_RESOURCES, PA_RESOURCE_TYPES, and PA_RESOURCE_TXN_ATTRIBUTES — joined via outer joins to supply resource identifiers and types.
  • HR_ALL_ORGANIZATION_UNITS_TL — supplies the organization name in the session language.

Several HR packages (HR_GENERAL, HR_PERSON_NAME, HR_SECURITY) and the package PA_RESOURCE_UTILS are listed as referenced objects, indicating that security predicates or helper logic may be applied by the consuming application rather than embedded in the view text itself.

Key Columns

Common Use Cases and Queries

The view is commonly used to search for eligible resources by name, to validate whether a person is currently eligible before creating a project assignment, and to feed resource lists into concurrent programs or reports.

Searching by first name, the term the user entered:

SELECT resource_source_id, resource_name, resource_first_name, resource_last_name, resource_number, person_type FROM apps.pa_c_elig_resource_v WHERE UPPER(resource_first_name) = 'JOHN' ORDER BY resource_last_name;

Listing eligible contingent workers with their organization:

SELECT resource_name, resource_number, name organization, assignment_start_date FROM apps.pa_c_elig_resource_v WHERE person_type = 'CWK' AND assignment_end_date > SYSDATE;

Because the view applies HR security and organization filters dynamically, results honour the responsibility-level access of the querying user, making it suitable for both interactive lookups and batch integration extracts.