Search Results manager_id

Overview

PA_RESOURCES_DENORM is a denormalized table in the Oracle Projects (PA) schema that stores pre-joined resource attributes for reporting and inquiry purposes. Rather than requiring application code or reports to traverse the normalized PA_RESOURCES table and join outward to PER_JOBS, HR_ALL_ORGANIZATION_UNITS, and other HR objects for every resource lookup, PA_RESOURCES_DENORM flattens the most frequently accessed descriptive attributes into a single wide row keyed by person and effective date. It is owned by the PA schema and carries a VALID status in both Oracle E-Business Suite 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the heuristic classification of PA_RESOURCES_DENORM is link. This classification is derived from its foreign key structure: the table sits at the intersection of PER_JOBS (JOB_ID), HR_ALL_ORGANIZATION_UNITS (RESOURCE_ORGANIZATION_ID), and PA_RESOURCES (RESOURCE_ID), and therefore functions as a relationship-bearing artifact rather than a pure hub of a single business concept or a satellite of descriptive history. The table should be understood as a denormalized convenience structure that materializes relationships and attributes together for performance, not as a system of record.

Key Information Stored

The table contains 30 documented columns. The most significant identity and relationship columns are:

PERSON_ID — the person identifier carried from HR; together with RESOURCE_EFFECTIVE_START_DATE it forms the unique business key candidate PA_RESOURCES_DENORM_U1.
RESOURCE_ID — the surrogate primary key of the underlying PA_RESOURCES record; the FK to PA_RESOURCES.
RESOURCE_EFFECTIVE_START_DATE and RESOURCE_EFFECTIVE_END_DATE — the date-bounded validity window of the denormalized row.
RESOURCE_NAME, RESOURCE_TYPE, and RESOURCE_PERSON_TYPE — descriptive classification of the resource.
RESOURCE_ORGANIZATION_ID and RESOURCE_ORG_ID — organization references, the former with an FK to HR_ALL_ORGANIZATION_UNITS.
RESOURCE_COUNTRY_CODE, RESOURCE_COUNTRY, RESOURCE_REGION, and RESOURCE_CITY — geographic attributes maintained for reporting.
RESOURCE_JOB_LEVEL and JOB_ID — job classification, with JOB_ID carrying an FK to PER_JOBS.
MANAGER_ID and MANAGER_NAME — the reporting manager of the resource.
EMPLOYEE_FLAG, BILLABLE_FLAG, UTILIZATION_FLAG, and SCHEDULABLE_FLAG — operational status indicators used in staffing and utilization reporting.

The surrogate key concept is represented by RESOURCE_ID, while the documented business-key candidate is the composite unique index PA_RESOURCES_DENORM_U1 on PERSON_ID and RESOURCE_EFFECTIVE_START_DATE. Standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and the program/concurrent columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) are also present.

Common Use Cases and Queries

The primary use case is resource-level reporting where denormalized attributes are needed without joining PA_RESOURCES to HR tables. Typical patterns include a time-bounded resource lookup by person, and a filter on billable or schedulable resources for staffing analysis:

Point-in-time lookup: SELECT RESOURCE_ID, RESOURCE_NAME, RESOURCE_JOB_LEVEL, MANAGER_NAME FROM PA_RESOURCES_DENORM WHERE PERSON_ID = :p_person_id AND TRUNC(SYSDATE) BETWEEN RESOURCE_EFFECTIVE_START_DATE AND RESOURCE_EFFECTIVE_END_DATE.
Staffing/capability reporting: filtering by BILLABLE_FLAG, UTILIZATION_FLAG, and SCHEDULABLE_FLAG combined with RESOURCE_ORGANIZATION_ID to produce organization-level resource inventories.
Geographic distribution reporting: grouping by RESOURCE_COUNTRY, RESOURCE_REGION, and RESOURCE_CITY for resource-allocation dashboards.

Because the table is denormalized, it is generally treated as read-oriented; direct DML should be avoided in favor of the processes that populate it from PA_RESOURCES and HR.

Related Objects

The documented foreign keys and parent relationships anchor PA_RESOURCES_DENORM to the following objects:

PA_RESOURCES — primary relationship via RESOURCE_ID; the normalized source of resource records.
PER_JOBS — joined on JOB_ID to supply job definition data.
HR_ALL_ORGANIZATION_UNITS — joined on RESOURCE_ORGANIZATION_ID for organization attributes.
PER_ALL_PEOPLE_F — implicit parent of PERSON_ID for person-level attributes across date ranges.
PER_ALL_ASSIGNMENTS_F — typical upstream source of job and organization context that feeds the denormalized columns.
PA_RESOURCE_TXN_ATTRIBUTES and PA_PROJECT_PARTIES — commonly queried alongside for resource-role and assignment context.

These relationships should be validated against the specific 12.1.1 or 12.2.2 instance, as denormalized maintenance processes differ by release and patch level.

Table: PA_RESOURCES_DENORM 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_RESOURCES_DENORM, object_name:PA_RESOURCES_DENORM, status:VALID, product: PA - Projects , description: PA_RESOURCES_DENORM is a denormalized table containing attributes for resources. , implementation_dba_data: PA.PA_RESOURCES_DENORM ,
Table: PA_RESOURCES_DENORM 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_RESOURCES_DENORM, object_name:PA_RESOURCES_DENORM, status:VALID, product: PA - Projects , description: PA_RESOURCES_DENORM is a denormalized table containing attributes for resources. , implementation_dba_data: PA.PA_RESOURCES_DENORM ,
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.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 ,
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_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_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_RES_ORGS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_REP_UTIL_RES_ORGS_V, object_name:PA_REP_UTIL_RES_ORGS_V, status:VALID, product: PA - Projects , description: View to display Manager-,by Organizations , implementation_dba_data: APPS.PA_REP_UTIL_RES_ORGS_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_ORGS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_REP_RES_ORGS_V, object_name:PA_REP_RES_ORGS_V, status:VALID, product: PA - Projects , description: PA_REP_RES_ORGS_V is a view that lists all organizations of the resources for the manager , implementation_dba_data: APPS.PA_REP_RES_ORGS_V ,
View: PA_REP_RES_ORGS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_REP_RES_ORGS_V, object_name:PA_REP_RES_ORGS_V, status:VALID, product: PA - Projects , description: PA_REP_RES_ORGS_V is a view that lists all organizations of the resources for the manager , implementation_dba_data: APPS.PA_REP_RES_ORGS_V ,
View: PA_REP_UTIL_RES_ORGS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_REP_UTIL_RES_ORGS_V, object_name:PA_REP_UTIL_RES_ORGS_V, status:VALID, product: PA - Projects , description: View to display Manager-,by Organizations , implementation_dba_data: APPS.PA_REP_UTIL_RES_ORGS_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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.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_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_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_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_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 ,
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 ,