Search Results resource_middle_names




Overview
Explore in AI Chat

Overview

PA_C_RES_ASGN_V is an APPS-owned database view in the Oracle E-Business Suite Projects (PA) module. It identifies all resources that are available for use at this time or in the future, drawing from human resources assignment and person data combined with Oracle Projects resource definitions. The view exposes a denormalized, read-only projection of the resource master, presenting each active employee resource alongside name components, resource identifiers, organization context, and assignment effective dates. Because it filters to currently valid and future-available resources, it serves as a convenient reporting and integration entry point for queries that require a list of assignable project resources without the complexity of joining the underlying HR and Projects base tables directly. The view has a status of VALID and is referenced by reporting extracts, project staffing reports, and downstream integrations that need resource names and numbers.

Underlying Base Objects

PA_C_RES_ASGN_V is defined over a set of HR and Projects objects. The documented referenced base objects include the views PER_PEOPLE_F and PER_ASSIGNMENTS_F, the synonyms PER_ASSIGNMENT_STATUS_TYPES, PA_RESOURCES, PA_RESOURCE_TXN_ATTRIBUTES, PA_RESOURCE_TYPES, PA_ALL_ORGANIZATIONS, and PA_IMPLEMENTATIONS, together with the packages PA_RESOURCE_UTILS, HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY. In the view text, PER_PEOPLE_F supplies person identity and name attributes; PER_ASSIGNMENTS_F supplies the primary employee assignment, organization, and effective dates; PER_ASSIGNMENT_STATUS_TYPES restricts the result set to assignments with a PER_SYSTEM_STATUS of ACTIVE_ASSIGN; and PA_RESOURCES and PA_RESOURCE_TYPES supply the Projects resource and resource type definitions. PA_ALL_ORGANIZATIONS constrains rows to organizations in use for EXPENDITURES that are not inactive, while PA_RESOURCE_TXN_ATTRIBUTES is joined outer to enrich the resource with transaction attributes. PA_IMPLEMENTATIONS ties the operating unit to the implementation, and PA_RESOURCE_UTILS.GET_ORGANIZATION_NAME resolves organization names. Because the view depends on date-effective HR tables (PER_PEOPLE_F, PER_ASSIGNMENTS_F), it is version-aware and returns the row effective at the current date.

Key Columns

Common Use Cases and Queries

The view is typically used to retrieve the current population of assignable resources for staffing, utilization, and name-based lookups. A common pattern selects the resource identity and name components, for example:

  • SELECT resource_id, resource_number, resource_name, resource_middle_names, resource_organization_name FROM pa_c_res_asgn_v; — lists available resources with their middle names.
  • SELECT resource_name, resource_number FROM pa_c_res_asgn_v WHERE resource_organization_id = :org_id ORDER BY resource_name; — resources within a given organization.
  • SELECT resource_id, resource_name FROM pa_c_res_asgn_v WHERE UPPER(resource_name) LIKE UPPER('%SMITH%'); — name search across full names.
  • Joining to project assignment or expenditure tables on RESOURCE_ID to attribute effort or cost to assignable resources.

Because the view is restricted to resources that are available now or in the future, it is appropriate for forward-looking reporting and should not be relied upon for historical resource availability without additional date-effective logic.