Search Results search_exp_org_hierarchy




Overview
Explore in AI Chat

Overview

PA_REQUIREMENTS_AMG_V is an APPS-owned database view in the Oracle E-Business Suite Projects (PA) module with a status of VALID. Its documented purpose is to show all project requirements, exposing staffing and assignment demand records in a flattened, denormalized form suitable for reporting, integration, and inquiry. The view is registered in the ETRM metadata for both Oracle EBS 12.1.1 and 12.2.2 and is composed primarily from PA_PROJECT_ASSIGNMENTS, PA_PROJECTS_ALL, and a set of supporting lookup, organization, and territory objects.

The view belongs to the "AMG" family of project requirement objects, which underpin Oracle's resource and staffing functionality. Because it joins project context, assignment details, expenditure organization information, and search criteria into a single row per assignment, it is commonly used where consumers need staffing demand data without navigating the underlying normalized assignment tables. The user search term "search_exp_org_hierarchy" corresponds directly to a column exposed by this view: POS.NAME is aliased as SEARCH_EXP_ORG_HIERARCHY, alongside SEARCH_EXP_ORG_STRUCT_VER_ID, SEARCH_EXP_START_ORG_ID, SEARCH_COUNTRY_CODE, and SEARCH_MIN_CANDIDATE_SCORE.

Underlying Base Objects

The documented view definition references a broad set of base objects. The primary synonyms are PA_PROJECT_ASSIGNMENTS and PA_PROJECTS_ALL, which supply the project and staffing assignment data. Supporting project objects include PA_PROJECT_STATUSES, PA_PROJECT_ROLE_TYPES, PA_PROJECT_SUBTEAMS, PA_PROJECT_SUBTEAM_PARTIES, PA_WORK_TYPES_V, PA_LOOKUPS, PA_LOCATIONS, PA_ACTION_SETS, and the PA_ADVERTISED_OPEN_REQ_V view.

Several columns are populated through packaged PL/SQL functions rather than direct joins. PA_RESOURCE_PVT.GET_MANAGER_ID and GET_MANAGER_NAME return the project manager, while PA_EXPENDITURES_UTILS.GETORGTLNAME resolves organization names for the expenditure organization identifiers. Other referenced packages include FND_GLOBAL, PA_RESOURCE_UTILS, and PA_ROLE_JOB_BG_UTILS. Human resources objects include HR_ALL_ORGANIZATION_UNITS, PER_JOBS, PER_JOB_GROUPS, PER_ORGANIZATION_STRUCTURES, and PER_ORG_STRUCTURE_VERSIONS, while FND_TERRITORIES_TL and JTF_CALENDARS_TL provide territory and calendar descriptions.

Key Columns

The view exposes the following principal columns:

Common Use Cases and Queries

Because the view flattens project assignment and staffing demand data, it is commonly used for requirement reporting, staffing analysis, integration extracts, and organizational hierarchy lookups. A typical query retrieving requirements for a project is:

  • SELECT project_id, name, assignment_name, status_code, start_date, end_date FROM pa_requirements_amg_v;
  • SELECT project_id, search_exp_org_hierarchy, search_min_candidate_score FROM pa_requirements_amg_v;
  • SELECT assignment_id, assignment_name, search_exp_start_org_id, staffing_priority_code FROM pa_requirements_amg_v WHERE multiple_status_flag = 'Y';

When filtering by qualification or advertisement status, note that PA_ADVERTISED_OPEN_REQ_V and PA_ACTION_SETS are referenced in the definition. Reports commonly join PROJECT_ROLE_NAME and WORK_TYPE_NAME to categorize demand, and use expenditure organization names to group requirements by the organization responsible for the assignment. Both 12.1.1 and 12.2.2 expose identical column semantics, making the view portable across releases; however, validation of search hierarchy values requires the organization structure version to be resolved through PER_ORG_STRUCTURE_VERSIONS.