Results for “search_country_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_PROJECT_OPEN_ASSNS_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite Projects (PA) module. It presents a consolidated, denormalized picture of staffing demand: open project assignments (staffing requirements) together with the project context, the carrying-out organization, hiring manager information, assignment attributes, matching/search configuration, and location and country details. The view is not a base transactional table but a query-optimized presentation layer intended for inquiry screens, search pages, and integration extract programs that need to evaluate open assignments against candidate resources.

The view's most notable characteristic is its extensive denormalization. Rather than requiring the caller to join PA_PROJECT_ASSIGNMENTS, PA_PROJECTS_ALL, HR_ALL_ORGANIZATION_UNITS, PA_LOCATIONS, PA_PROJECT_STATUSES, and several lookup and territory tables, the view performs these joins internally and exposes scalar values directly. It also invokes PL/SQL functions from the PA_RESOURCE_PVT, PA_PROJECTS_MAINT_UTILS, and PA_EXPENDITURES_UTILS packages, so several columns are derived at query execution time rather than stored on a base table. This makes the view convenient for read-only reporting but comparatively expensive for high-volume batch processing.

The user search term "search_exp_start_org" maps directly to a column exposed by this view. SEARCH_EXP_START_ORG is the translated (territory-language) name of the organization identified by ASGN.SEARCH_EXP_START_ORG_ID, resolved through PA_EXPENDITURES_UTILS.GETORGTLNAME. It designates the starting organization for the experience-based search hierarchy used when the system automatically proposes candidate resources for an open assignment.

Underlying Base Objects

The documented base objects underlying the view span Projects, HR, and common lookup schemas:

• PA_PROJECT_ASSIGNMENTS — the primary driver, supplying assignment attributes, dates, status, matching weightings, and search configuration columns.
• PA_PROJECTS_ALL — project name, number (SEGMENT1), carrying-out organization, and the automated-search enablement flag.
• PA_PROJECT_STATUSES and PA_LOOKUPS / PA_PROJECT_ROLE_TYPES / PA_WORK_TYPES_V — decode assignment status, staffing priority, and project role and work-type meanings.
• HR_ALL_ORGANIZATION_UNITS — organizational name context; PER_ORGANIZATION_STRUCTURES and PER_ORG_STRUCTURE_VERSIONS describe the search organization hierarchy and its version.
• PA_LOCATIONS, FND_TERRITORIES_TL — city, region, and country names for both the assignment location and the search country.
• JTF_CALENDARS_TL — calendar name associated with the assignment.
• PA_ADVERTISED_OPEN_REQ_V, PA_PROJECT_PARTIES_UTILS, PA_ACTION_SETS, PER_JOBS, PER_JOB_GROUPS, and PA_ROLE_JOB_BG_UTILS — supporting views and packages used in role, job, and subteam resolution.
• PL/SQL functions — PA_RESOURCE_PVT.GET_MANAGER_ID/NAME, PA_PROJECTS_MAINT_UTILS.GET_PRIMARY_CUSTOMER_NAME, and PA_EXPENDITURES_UTILS.GETORGTLNAME supply manager, customer, and organization-name derivations.

Key Columns

• PROJECT_ID, NAME, SEGMENT1 — project identity and number; a concatenated project display string is also exposed.
• ASSIGNMENT_ID, ASSIGNMENT_NAME, ASSIGNMENT_NUMBER, DESCRIPTION — the open assignment's identity.
• START_DATE, END_DATE, ASSIGNMENT_DURATION — duration is computed as TRUNC(END_DATE) − TRUNC(START_DATE) + 1.
• STATUS_CODE, STAFFING_PRIORITY_CODE, COMPETENCE_MATCH_WEIGHTING, AVAILABILITY_MATCH_WEIGHTING, JOB_LEVEL_MATCH_WEIGHTING — staffing state and matching configuration.
• SEARCH_EXP_START_ORG_ID / SEARCH_EXP_START_ORG — the search experience starting organization and its translated name, the column referenced by the search term.
• SEARCH_EXP_ORG_STRUCT_VER_ID, SEARCH_EXP_ORG_HIERARCHY — the organization structure version and hierarchy used for experience-based search.
• SEARCH_MIN_AVAILABILITY, SEARCH_MIN_CANDIDATE_SCORE, SEARCH_COUNTRY_CODE, SEARCH_COUNTRY_NAME — candidate qualification thresholds.
• EXPENDITURE_ORG_ID, EXPENSE_OWNER, EXPENSE_LIMIT, EXTENSION_POSSIBLE — financial and extension attributes of the assignment.
• PROJECT_ROLE_NAME, WORK_TYPE_ID, PROJECT_SUBTEAM_ID — classification of the staffing need.

Common Use Cases and Queries

Typical consumers include the staffing/assignment search user interfaces, open-requirement reports, and interfaces feeding resource-management or third-party talent systems. A common pattern is to filter on assignment status and date range, then inspect the search-organization configuration.

Example — open assignments and their search starting organization:

SELECT project_id, name, assignment_id, assignment_name, start_date, end_date, search_exp_start_org, search_exp_start_org_id, search_country_name, search_min_candidate_score
FROM apps.pa_project_open_assns_v
WHERE status_code = 'OPEN'
AND TRUNC(start_date) >= TRUNC(SYSDATE);

Example — assignments configured for automated search within a specific starting organization:

SELECT assignment_number, assignment_name, search_exp_org_hierarchy, search_exp_start_org, search_min_availability
FROM apps.pa_project_open_assns_v
WHERE search_exp_start_org_id = :p_org_id
AND enable_automated_search = 'Y';

Because many columns are function-derived, queries should restrict the driving rows (for example, by project or date) before invoking the view on large data sets. Callers should also be aware that translated organization and territory names depend on the session's language environment, and that rows reflect the current state of the underlying assignment records rather than a historical snapshot.