Search Results manager_name




Overview
Explore in AI Chat

Overview

PA_REP_ALL_RES_MGR_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered with the Projects (PA) product family. It is documented as VALID in ETRM for releases 12.1.1 and 12.2.2 and is classified as a VIEW object. Its stated purpose is to expose the set of "starting resource managers" to which the current user has access, derived from that user's security profile and grants. In practice the view is a security-filtered lookup of manager identifiers and manager names, used by Oracle Projects reporting and by integration points that must present a manager selection list without exposing managers the signed-in user is not entitled to see. The view name reflects its three functional parts: PA (Projects), REP (reporting), ALL (all applicable managers across the security boundary), and RES_MGR (resource manager).

Underlying Base Objects

The documented base objects referenced by the view are FND_GLOBAL (package), FND_GRANTS, FND_OBJECTS, FND_PROFILE, FND_USER, PA_REP_RES_MGR_V (view), PA_RESOURCES_DENORM, PA_RESOURCE_UTILS (package), PA_SECURITY_PVT (package), and DUAL. The view definition is a compound query with UNION, UNION ALL, and inline subqueries. The first branch joins PA_REP_RES_MGR_V to PA_RESOURCES_DENORM and includes a profile check on PA_SUPER_RESOURCE. The second branch selects distinct MANAGER_ID and MANAGER_NAME values from PA_RESOURCES_DENORM where SYSDATE falls between RESOURCE_EFFECTIVE_START_DATE and RESOURCE_EFFECTIVE_END_DATE, restricted by organization-level grants joined through FND_GRANTS, FND_OBJECTS, and FND_USER. The third branch, using UNION ALL, returns all dated managers when the PA_SUPER_RESOURCE profile is set to 'Y'. The menu identifier for resource authorization is obtained through PA_SECURITY_PVT.GET_MENU_ID('PA_PRM_RES_AUTH'), while PA_RESOURCE_UTILS and FND_GLOBAL supply supporting security and session context.

Key Columns

According to the documented column list, the view exposes two columns: STARTING_MANAGER_ID and STARTING_MANAGER_NAME. Both originate from the underlying PA_RESOURCES_DENORM records, where MANAGER_ID identifies the manager and MANAGER_NAME holds the display name. The view text aliases these as RES_MGR.MANAGER_ID and RES_MGR.MANAGER_NAME in the first and second branches, and equivalently in the final UNION ALL branch. The search term "manager_name" therefore maps directly to STARTING_MANAGER_NAME, which is the column consumers typically project for display and filter on for name-based searching. Records are only eligible when MANAGER_NAME IS NOT NULL and the manager record is effective on the current system date.

Common Use Cases and Queries

Typical usage is to populate a manager list-of-values in a Projects form or concurrent report, or to constrain reporting output to the managers a user is authorized to view. A basic lookup follows:

  • SELECT starting_manager_id, starting_manager_name FROM apps.pa_rep_all_res_mgr_v ORDER BY starting_manager_name;
  • SELECT starting_manager_id, starting_manager_name FROM apps.pa_rep_all_res_mgr_v WHERE UPPER(starting_manager_name) LIKE UPPER(:p_name)||'%';
  • SELECT starting_manager_id, COUNT(*) FROM apps.pa_rep_all_res_mgr_v GROUP BY starting_manager_id;

Because the view applies profile and grant logic internally, callers do not need to add organization security predicates. Note that the returned set is user-dependent and date-sensitive: results vary with the FND_GLOBAL.USER_ID session value, active FND_GRANTS rows, and the PA_SUPER_RESOURCE profile setting. For performance-sensitive reporting, materialize or cache the result rather than invoking the view repeatedly, as it exercises several security joins and inline subqueries.

  • 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_UTIL_MGR_ORG_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_MGR_ORG_V,  object_name:PA_REP_UTIL_MGR_ORG_V,  status:VALID,  product: PA - Projects ,  description: View to display Organization by, -Managers ,  implementation_dba_data: APPS.PA_REP_UTIL_MGR_ORG_V , 

  • View: PA_REP_UTIL_MGR_ORG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_MGR_ORG_V,  object_name:PA_REP_UTIL_MGR_ORG_V,  status:VALID,  product: PA - Projects ,  description: View to display Organization by, -Managers ,  implementation_dba_data: APPS.PA_REP_UTIL_MGR_ORG_V , 

  • View: PA_REP_RES_MGR_V 12.1.1

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

  • View: PA_REP_RES_MGR_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_MGR_V,  object_name:PA_REP_RES_MGR_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_MGR_V is a view that list all direct and indirect managers in HR for a given application user ,  implementation_dba_data: APPS.PA_REP_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_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_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_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 , 

  • 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_C_RES_DETAILS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_C_RES_DETAILS_V,  object_name:PA_C_RES_DETAILS_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_C_RES_DETAILS_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_MGR_ORG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MGR_ORG_V,  object_name:PA_REP_MGR_ORG_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_MGR_ORG_V is a view that lists all managers for the given organization ,  implementation_dba_data: APPS.PA_REP_MGR_ORG_V , 

  • View: PA_REP_MGR_ORG_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MGR_ORG_V,  object_name:PA_REP_MGR_ORG_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_MGR_ORG_V is a view that lists all managers for the given organization ,  implementation_dba_data: APPS.PA_REP_MGR_ORG_V , 

  • View: PA_REP_UTIL_RESVW_GE_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_RESVW_GE_V,  object_name:PA_REP_UTIL_RESVW_GE_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_RESVW_GE_V is a view to provide Capacity and Total Hours values for resources across Global Week. This information is used by Disco Workbooks. ,  implementation_dba_data: APPS.PA_REP_UTIL_RESVW_GE_V , 

  • View: PA_REP_UTIL_RESVW_GE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_RESVW_GE_V,  object_name:PA_REP_UTIL_RESVW_GE_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_RESVW_GE_V is a view to provide Capacity and Total Hours values for resources across Global Week. This information is used by Disco Workbooks. ,  implementation_dba_data: APPS.PA_REP_UTIL_RESVW_GE_V , 

  • View: PA_RES_SCH_TIME_CHART_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_SCH_TIME_CHART_V,  object_name:PA_RES_SCH_TIME_CHART_V,  status:VALID,  product: PA - Projects ,  description: The purpose of this view is to provide the time chart data for the resource schedule timeline ,  implementation_dba_data: APPS.PA_RES_SCH_TIME_CHART_V , 

  • View: PA_REP_UTIL_RESVW_PA_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_RESVW_PA_V,  object_name:PA_REP_UTIL_RESVW_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_RESVW_PA_V is a view to provide Capacity and Total Hours values for resources across Global Week. This information is used by Disco Workbooks. ,  implementation_dba_data: APPS.PA_REP_UTIL_RESVW_PA_V , 

  • View: PA_REP_RESOURCES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RESOURCES_V,  object_name:PA_REP_RESOURCES_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RESOURCES_V is a secured view that lists resources ,  implementation_dba_data: APPS.PA_REP_RESOURCES_V , 

  • View: PA_PROJECT_ASSIGNMENTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJECT_ASSIGNMENTS_V,  object_name:PA_PROJECT_ASSIGNMENTS_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_PROJECT_ASSIGNMENTS_V , 

  • View: PA_RES_SCH_TIME_CHART_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_SCH_TIME_CHART_V,  object_name:PA_RES_SCH_TIME_CHART_V,  status:VALID,  product: PA - Projects ,  description: The purpose of this view is to provide the time chart data for the resource schedule timeline ,  implementation_dba_data: APPS.PA_RES_SCH_TIME_CHART_V , 

  • View: PA_REP_RESOURCES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RESOURCES_V,  object_name:PA_REP_RESOURCES_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RESOURCES_V is a secured view that lists resources ,  implementation_dba_data: APPS.PA_REP_RESOURCES_V , 

  • View: PA_REP_UTIL_RESVW_GL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_RESVW_GL_V,  object_name:PA_REP_UTIL_RESVW_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_RESVW_GL_V is a view to provide Capacity and Total Hours values for resources across Global Week. This information is used by Disco Workbooks. ,  implementation_dba_data: APPS.PA_REP_UTIL_RESVW_GL_V , 

  • View: PA_REP_UTIL_RESVW_PA_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_RESVW_PA_V,  object_name:PA_REP_UTIL_RESVW_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_RESVW_PA_V is a view to provide Capacity and Total Hours values for resources across Global Week. This information is used by Disco Workbooks. ,  implementation_dba_data: APPS.PA_REP_UTIL_RESVW_PA_V , 

  • View: PA_REP_RES_CAP_PA_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_CAP_PA_V,  object_name:PA_REP_RES_CAP_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_CAP_PA_V is a view that shows resource capacity hours for a pa period ,  implementation_dba_data: APPS.PA_REP_RES_CAP_PA_V , 

  • View: PA_REP_UTIL_RESVW_GL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_RESVW_GL_V,  object_name:PA_REP_UTIL_RESVW_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_RESVW_GL_V is a view to provide Capacity and Total Hours values for resources across Global Week. This information is used by Disco Workbooks. ,  implementation_dba_data: APPS.PA_REP_UTIL_RESVW_GL_V , 

  • View: PA_REP_RES_CAP_GL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_CAP_GL_V,  object_name:PA_REP_RES_CAP_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_CAP_GL_V is a view that shows resource capacity hours for a gl_period ,  implementation_dba_data: APPS.PA_REP_RES_CAP_GL_V , 

  • View: PA_RES_OVC_HOURS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_OVC_HOURS_V,  object_name:PA_RES_OVC_HOURS_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_OVC_HOURS_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_OVC_HOURS_V , 

  • View: PA_REP_RES_CAP_PA_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_CAP_PA_V,  object_name:PA_REP_RES_CAP_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_CAP_PA_V is a view that shows resource capacity hours for a pa period ,  implementation_dba_data: APPS.PA_REP_RES_CAP_PA_V , 

  • View: PA_RES_OVC_HOURS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_OVC_HOURS_V,  object_name:PA_RES_OVC_HOURS_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_OVC_HOURS_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_OVC_HOURS_V , 

  • View: PA_REP_RES_CAP_GL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_CAP_GL_V,  object_name:PA_REP_RES_CAP_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_CAP_GL_V is a view that shows resource capacity hours for a gl_period ,  implementation_dba_data: APPS.PA_REP_RES_CAP_GL_V , 

  • View: PA_REP_PROJ_REQHRS_WK_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_REQHRS_WK_V,  object_name:PA_REP_PROJ_REQHRS_WK_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_PROJ_REQHRS_WK_V is a view that shows required project hours for global expenditure week ,  implementation_dba_data: APPS.PA_REP_PROJ_REQHRS_WK_V , 

  • View: PA_REP_RES_AVL_WK_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_AVL_WK_V,  object_name:PA_REP_RES_AVL_WK_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_AVL_WK_V is a view that shows resource capacity for a gloabl week ,  implementation_dba_data: APPS.PA_REP_RES_AVL_WK_V , 

  • View: PA_RES_AVL_HOURS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_AVL_HOURS_V,  object_name:PA_RES_AVL_HOURS_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_AVL_HOURS_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_AVL_HOURS_V , 

  • View: PA_RES_AVL_HOURS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_AVL_HOURS_V,  object_name:PA_RES_AVL_HOURS_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_AVL_HOURS_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_AVL_HOURS_V , 

  • View: PA_REP_RES_AVL_WK_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_AVL_WK_V,  object_name:PA_REP_RES_AVL_WK_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_AVL_WK_V is a view that shows resource capacity for a gloabl week ,  implementation_dba_data: APPS.PA_REP_RES_AVL_WK_V , 

  • View: PA_REP_ORG_RES_COMP_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_RES_COMP_V,  object_name:PA_REP_ORG_RES_COMP_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ORG_RES_COMP_V is a view that lists all resource competence details by organizations ,  implementation_dba_data: APPS.PA_REP_ORG_RES_COMP_V , 

  • View: PA_REP_RES_CAP_WKD_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_CAP_WKD_V,  object_name:PA_REP_RES_CAP_WKD_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_CAP_WKD_V is a view that shows resource capacity for a gloabl week ,  implementation_dba_data: APPS.PA_REP_RES_CAP_WKD_V , 

  • View: PA_REP_PROJ_REQHRS_WK_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_REQHRS_WK_V,  object_name:PA_REP_PROJ_REQHRS_WK_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_PROJ_REQHRS_WK_V is a view that shows required project hours for global expenditure week ,  implementation_dba_data: APPS.PA_REP_PROJ_REQHRS_WK_V , 

  • View: PA_RES_SCH_TIMELINE_ROWLBL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_SCH_TIMELINE_ROWLBL_V,  object_name:PA_RES_SCH_TIMELINE_ROWLBL_V,  status:VALID,  product: PA - Projects ,  description: The purpose of this view is to provide row label data for the resource schedule timeline ,  implementation_dba_data: APPS.PA_RES_SCH_TIMELINE_ROWLBL_V , 

  • View: PA_RES_SCH_TIMELINE_ROWLBL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_SCH_TIMELINE_ROWLBL_V,  object_name:PA_RES_SCH_TIMELINE_ROWLBL_V,  status:VALID,  product: PA - Projects ,  description: The purpose of this view is to provide row label data for the resource schedule timeline ,  implementation_dba_data: APPS.PA_RES_SCH_TIMELINE_ROWLBL_V , 

  • View: PA_REP_UTIL_RWTVW_GE_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_RWTVW_GE_V,  object_name:PA_REP_UTIL_RWTVW_GE_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_RWTVW_GE_V is a view to provide Total Hours and Total Weighted Hours values for resources across Global Week. This information is used by Disco Workbooks. ,  implementation_dba_data: APPS.PA_REP_UTIL_RWTVW_GE_V , 

  • View: PA_REP_RES_CAP_WKD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_CAP_WKD_V,  object_name:PA_REP_RES_CAP_WKD_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_CAP_WKD_V is a view that shows resource capacity for a gloabl week ,  implementation_dba_data: APPS.PA_REP_RES_CAP_WKD_V , 

  • View: PA_REP_ORG_RES_COMP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_RES_COMP_V,  object_name:PA_REP_ORG_RES_COMP_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ORG_RES_COMP_V is a view that lists all resource competence details by organizations ,  implementation_dba_data: APPS.PA_REP_ORG_RES_COMP_V , 

  • View: PA_REP_RES_OVC_WK_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_OVC_WK_V,  object_name:PA_REP_RES_OVC_WK_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_OVC_WK_V is a view that shows resource capacity for a gloabl week ,  implementation_dba_data: APPS.PA_REP_RES_OVC_WK_V , 

  • View: PA_REP_RES_OVC_WK_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_OVC_WK_V,  object_name:PA_REP_RES_OVC_WK_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_OVC_WK_V is a view that shows resource capacity for a gloabl week ,  implementation_dba_data: APPS.PA_REP_RES_OVC_WK_V , 

  • View: PA_REP_PROJ_REQHRS_PA_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_REQHRS_PA_V,  object_name:PA_REP_PROJ_REQHRS_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_PROJ_REQHRS_PA_V is a view that shows required project hours for a pa period ,  implementation_dba_data: APPS.PA_REP_PROJ_REQHRS_PA_V , 

  • View: PA_REP_UTIL_RWTVW_GE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_RWTVW_GE_V,  object_name:PA_REP_UTIL_RWTVW_GE_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_RWTVW_GE_V is a view to provide Total Hours and Total Weighted Hours values for resources across Global Week. This information is used by Disco Workbooks. ,  implementation_dba_data: APPS.PA_REP_UTIL_RWTVW_GE_V , 

  • View: PA_REP_PROJ_REQHRS_PA_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_REQHRS_PA_V,  object_name:PA_REP_PROJ_REQHRS_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_PROJ_REQHRS_PA_V is a view that shows required project hours for a pa period ,  implementation_dba_data: APPS.PA_REP_PROJ_REQHRS_PA_V ,