Search Results starting_manager_name




Overview
Explore in AI Chat

Overview

PA_REP_MANAGERS_DIST_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the PA (Projects) product family. Its documented purpose is to expose a de-duplicated list of resource managers, specifically described in the ETRM metadata as a view that "shows all distinct resource managers." Because it is a view and not a base table, it carries no storage of its own; it is a query definition that returns rows from an underlying Projects resource table. Its status is VALID in both 12.1.1 and 12.2.2, meaning the definition is intact and usable in each release. The view is primarily consumed by Oracle Projects reporting components and by customer-built reports, concurrent programs, and integrations that require a clean, distinct list of managers without the redundant rows that can exist in the denormalized source data.

Underlying Base Objects

The documented view text shows that PA_REP_MANAGERS_DIST_V is defined over a single referenced base object, PA_RESOURCES_DENORM, which is exposed in the APPS schema as a synonym. The view applies a DISTINCT operator to the selected columns, so the returned result set contains one row per unique manager. The denormalized source table PA_RESOURCES_DENORM aggregates resource attributes and manager information in a form optimized for read access, which is why the view can project manager columns directly without additional joins. The ETRM metadata lists PA_RESOURCES_DENORM (SYNONYM) as the sole referenced object, confirming that no other tables are joined in the definition.

Key Columns

The documented view text selects DISTINCT MANAGER_ID and MANAGER_NAME, while the ETRM column listing exposes STARTING_MANAGER_ID and STARTING_MANAGER_NAME. This naming difference reflects the internal source attributes versus the published column names available to consumers. The principal columns are:

  • STARTING_MANAGER_ID — The unique identifier of the resource manager. This is the column most commonly used in joins to HR and resource tables and is the field matched by searches on "starting_manager_id."
  • STARTING_MANAGER_NAME — The display name associated with the manager identifier, suitable for LOVs, reports, and list displays.

Because the view is de-duplicated, each manager identifier appears once, which makes it well suited as a lookup source for validated manager selections.

Common Use Cases and Queries

Typical scenarios include populating manager selection lists, filtering project or resource reports by manager, and feeding integration extracts that require a distinct manager population. A representative query joining the view to resource assignments is shown below.

  • Listing all managers: SELECT DISTINCT starting_manager_id, starting_manager_name FROM apps.pa_rep_managers_dist_v;
  • Filtering by a specific manager: SELECT starting_manager_id, starting_manager_name FROM apps.pa_rep_managers_dist_v WHERE starting_manager_id = :p_manager_id;
  • Joining to resources: SELECT m.starting_manager_id, m.starting_manager_name, r.resource_id FROM apps.pa_rep_managers_dist_v m, apps.pa_resources_denorm r WHERE r.starting_manager_id = m.starting_manager_id;

All queries should be issued against the APPS synonym, as the view is documented under the APPS owner. No database links or additional joins are required by the view definition itself.

  • View: PA_REP_MANAGERS_DIST_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MANAGERS_DIST_V,  object_name:PA_REP_MANAGERS_DIST_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_MANAGERS_DIST_V is a view that shows all distinct resource managers ,  implementation_dba_data: APPS.PA_REP_MANAGERS_DIST_V , 

  • View: PA_REP_MANAGERS_DIST_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MANAGERS_DIST_V,  object_name:PA_REP_MANAGERS_DIST_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_MANAGERS_DIST_V is a view that shows all distinct resource managers ,  implementation_dba_data: APPS.PA_REP_MANAGERS_DIST_V , 

  • View: PA_REP_MANAGERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MANAGERS_V,  object_name:PA_REP_MANAGERS_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RESOURCES_V is a secured view that lists all managers in the system ,  implementation_dba_data: APPS.PA_REP_MANAGERS_V , 

  • View: PA_REP_MANAGERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MANAGERS_V,  object_name:PA_REP_MANAGERS_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RESOURCES_V is a secured view that lists all managers in the system ,  implementation_dba_data: APPS.PA_REP_MANAGERS_V , 

  • View: PA_REP_ALL_RES_MGR_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_RES_MGR_V,  object_name:PA_REP_ALL_RES_MGR_V,  status:VALID,  product: PA - Projects ,  description: This view shows starting resource managers based on users security ,  implementation_dba_data: APPS.PA_REP_ALL_RES_MGR_V , 

  • View: PA_REP_ALL_RES_MGR_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_RES_MGR_V,  object_name:PA_REP_ALL_RES_MGR_V,  status:VALID,  product: PA - Projects ,  description: This view shows starting resource managers based on users security ,  implementation_dba_data: APPS.PA_REP_ALL_RES_MGR_V , 

  • View: PA_REP_ALL_MGR_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_MGR_V,  object_name:PA_REP_ALL_MGR_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ALL_MGR_V is a view that list all direct and indirect managers in HR for a given application user has a Resource Authority ,  implementation_dba_data: APPS.PA_REP_ALL_MGR_V , 

  • View: PA_REP_ALL_MGR_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_MGR_V,  object_name:PA_REP_ALL_MGR_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ALL_MGR_V is a view that list all direct and indirect managers in HR for a given application user has a Resource Authority ,  implementation_dba_data: APPS.PA_REP_ALL_MGR_V ,