Search Results fp_resource_list_id




Overview
Explore in AI Chat

Overview

The APPS.PA_PMC_RESOURCE_LIST_V view is a reporting and integration construct within the Oracle E-Business Suite Projects (PA) module. It consolidates resource list definitions that originate from two distinct functional areas: financial plan option resource lists associated with a specific plan type and project, and Project Management Consultant (PMC) budget-type resource lists. The view presents a unified, homogenous result set in which both categories are exposed through a common set of columns, allowing downstream reports, concurrent programs, and integration interfaces to consume resource list data without needing to understand the underlying source divergence.

The object is particularly relevant to users who search on the term "resource_list_name," since this is the primary descriptive column surfaced by the view. It functions as a lookup-style presentation layer, and is documented in ETRM under owner APPS for release 12.2.2, with applicability spanning the 12.1.1 and 12.2.2 code lines.

Underlying Base Objects

The view is defined by a UNION ALL of two independent SELECT statements, each drawn from a separate source and differentiated by a literal type discriminator.

  • PA_FP_OPTIONS_RESLISTS_V — supplies resource lists tied to a financial plan type and project. Joined in this branch to PA_RESOURCE_LISTS_ALL_BG.
  • PA_RESOURCE_LISTS_ALL_BG — a synonym (base object) providing the resource list name (BG.NAME) used in both branches.
  • PA_PMC_RESOURCE_LISTS_V — supplies the budget-type branch of the union, returning resource list ID and name.
  • PA_CROSS_BUSINESS_GRP (package) — referenced by the underlying view logic for cross-business-group security filtering.
  • FND_PROFILE (package) — referenced for profile option evaluations that govern filtering and access behavior.

The first branch carries a live financial plan type ID and project ID; the second branch substitutes the constant -1 for both, marking records as budget-type and project-independent.

Key Columns

  • RESOURCE_LIST_ID — the primary identifier of the resource list. In the plan-type branch it is sourced from FP_RESOURCE_LIST_ID; in the budget-type branch from RESOURCE_LIST_ID.
  • RESOURCE_LIST_NAME — the user-facing name of the resource list, sourced from PA_RESOURCE_LISTS_ALL_BG.NAME in the first branch and from PA_PMC_RESOURCE_LISTS_V in the second. This is the column most frequently queried by end users and reports.
  • FIN_PLAN_TYPE_ID — the financial plan type to which the resource list applies. A value of -1 identifies budget-type (PMC) entries.
  • FP_TYPE_CODE — a literal discriminator with the value 'PLAN_TYPE' for budget/plan records and 'BUDGET_TYPE' for PMC budget records, allowing consumers to segregate rows by origin.
  • PROJECT_ID — the owning project for plan-type rows; -1 for budget-type rows.

Common Use Cases and Queries

The view is typically used to validate resource list names, to populate LOV-style queries, and to drive reporting that must span both plan-type and budget-type resource lists.

SELECT resource_list_id,
       resource_list_name,
       fp_type_code,
       fin_plan_type_id,
       project_id
  FROM apps.pa_pmc_resource_list_v
 WHERE resource_list_name LIKE :search_name
 ORDER BY resource_list_name;

To isolate only PMC budget-type entries:

SELECT resource_list_id, resource_list_name
  FROM apps.pa_pmc_resource_list_v
 WHERE fp_type_code = 'BUDGET_TYPE';

To resolve the resource lists available to a specific project and plan type:

SELECT resource_list_id, resource_list_name
  FROM apps.pa_pmc_resource_list_v
 WHERE fp_type_code = 'PLAN_TYPE'
   AND project_id = :project_id
   AND fin_plan_type_id = :fin_plan_type_id;

Because the view relies on PA_CROSS_BUSINESS_GRP and FND_PROFILE, returned rows are subject to the operating unit, security, and profile context of the connecting user, and results should be interpreted within that session context.