Search Results resource_job_id




Overview
Explore in AI Chat

Overview

PA_C_RES_DETAILS_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 consolidates current human-resources and assignment attributes for project resources into a single denormalized row per person, exposing name, number, e-mail, job, organization, manager, supplier, and deployment-factor information. The view is commonly joined to project staffing, scheduling, and resource-assignment data, and its primary key is the RESOURCE_SOURCE_ID (PERSON_ID) column.

The name of the object is significant to the search term "resource_job_id": the view exposes a column RESOURCE_JOB_ID directly from the assignment record, making it the natural source for reporting or validating an employee's job in project contexts.

Underlying Base Objects

The view text joins a small set of HR and procurement objects:

The view also invokes several PL/SQL packages: PA_JOB_UTILS (GET_JOB_LEVEL, GET_JOB_NAME), PA_RESOURCE_UTILS (GET_PROJECTED_END_DATE), PA_SCHEDULE_UTILS (GET_RES_CALENDAR_NAME), HR_PERSON_TYPE_USAGE_INFO, HR_GENERAL, and HR_SECURITY. Each of these contributes derived attributes (mapped job name/level, projected end date, calendar name, user person type) or enforces security predicates.

Key Columns

Common Use Cases and Queries

Typical uses include resource-availability reports, staffing eligibility checks, and job-mapping audits. The following example retrieves the resource's job and related attributes:

SELECT resource_source_id,
       resource_name,
       resource_number,
       resource_job_id,
       resource_job_name,
       resource_job_level,
       mapped_job_name,
       resource_organization_name
  FROM apps.pa_c_res_details_v
 WHERE resource_job_id = :p_job_id;

A second pattern joins the view to assignment or planning tables by RESOURCE_SOURCE_ID to enrich staffing records with job and organizational detail. Because the view's predicates are time-bound (TRUNC(SYSDATE) BETWEEN the effective date ranges), callers should not apply additional effective-dating logic and should be aware that resources without a current primary assignment are excluded.

In summary, PA_C_RES_DETAILS_V is the canonical Projects-side view for resource master detail. Its RESOURCE_JOB_ID column is sourced straight from PER_ASSIGNMENTS_F and gives the assignment's job, complemented by the name, level, and mapped-job derivatives provided by PA_JOB_UTILS.