Search Results resource_country_code




Overview
Explore in AI Chat

Overview

PA_C_JOBLEVEL_RES_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 presents job level information together with historical, current, and future primary assignment details for all resources defined in Oracle Projects. Rather than storing data itself, the view consolidates person, assignment, job, organization, and address attributes into a single denormalized result set that reporting tools, extensions, and integrations can query without reproducing the complex join logic across the HR and Projects schemas.

The view is particularly relevant to resource management and staffing reports, where the job level of a resource must be resolved from the assignment's job and job group. The job level itself is not a stored column on the assignment; it is derived at runtime through the PA_HR_UPDATE_API.GET_JOB_LEVEL function, which accepts the job identifier and the job group identifier and returns the corresponding level. Because the view filters on SYSDATE between the person record's effective start and end dates and restricts assignments to primary employee or contingent worker assignments, the output reflects the effective state of each resource at the time of query execution.

Underlying Base Objects

The view is defined over a mixture of tables, synonyms, and views. The primary driving objects are PER_ASSIGNMENTS_F (assignments), PER_PEOPLE_F (person records), PER_JOBS (job definitions), PER_ADDRESSES (address details), and PER_ASSIGNMENT_STATUS_TYPES (assignment status validation). Termination and placement history are supplied through an inline UNION ALL of PER_PERIODS_OF_SERVICE and PER_PERIODS_OF_PLACEMENT. Resource-specific attributes come from PA_RESOURCES, PA_RESOURCE_TXN_ATTRIBUTES, PA_ALL_ORGANIZATIONS, and PA_RESOURCE_TYPES. Territory and organization lookups are resolved through FND_TERRITORIES_VL and the PA_RESOURCE_UTILS.GET_ORGANIZATION_NAME function.

Documented referenced objects also include HR_ORGANIZATION_INFORMATION, HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY. The presence of HR_SECURITY indicates that the view participates in Oracle HRMS security profiles, so row visibility is governed by the security profile assigned to the querying responsibility.

Key Columns

Common Use Cases and Queries

Typical scenarios include resource roster reporting by job level, billing rate derivation based on job level and organization, and country-based resource analysis for global staffing or compliance. The country columns are frequently used to group headcount, validate assignment locations, or drive regional approval routings.

  • Listing resources and their job levels for a given organization.
  • Filtering resources by RESOURCE_COUNTRY_CODE for regional reporting.
  • Identifying assignments active between two dates using the assignment start and end columns.
  • Feeding external HR or workforce planning systems with a stable resource-jobs-country extract.

Sample query:

SELECT resource_id, resource_number, resource_name, resource_job_name, resource_job_level, resource_organization_name, resource_country_code, resource_country_name, assignment_start_date, assignment_end_date FROM apps.pa_c_joblevel_res_v WHERE resource_country_code = 'US' AND TRUNC(SYSDATE) BETWEEN assignment_start_date AND NVL(assignment_end_date, SYSDATE) ORDER BY resource_name;