Search Results pa_summ_balances




Overview
Explore in AI Chat

Overview

The PA_SUMM_BALANCES table is a core data repository within the Oracle E-Business Suite Projects module (PA). Its primary function is to store aggregated financial balance information for reporting objects, serving as a critical performance layer for project accounting and financial reporting. By maintaining pre-summarized balances, it enables efficient generation of key reports—such as project performance, work-in-progress (WIP), and cost distribution summaries—without requiring real-time aggregation from vast transactional tables. This table is integral to the financial close and reporting processes in both Oracle EBS 12.1.1 and 12.2.2, providing a validated and structured source for analytical queries.

Key Information Stored

The table's structure is designed to hold summarized financial data linked to specific reporting periods and objects. Based on the provided metadata, the most critical columns include the object identifier and the accounting period reference. The OBJECT_ID column is a foreign key to PA_OBJECTS, linking each summarized balance to a specific project, task, or other reporting entity within the Projects module. The PERIOD_SET_NAME column is a foreign key to GL_PERIOD_SETS, anchoring the summarized data to a specific accounting calendar. While the specific balance columns (e.g., raw cost, burdened cost, revenue) are not detailed in the excerpt, the table typically stores aggregated amounts for key financial dimensions like actuals, commitments, and budget amounts, categorized by expenditure type, revenue category, or other natural account segments.

Common Use Cases and Queries

This table is primarily accessed for high-level financial analysis and standardized reporting. A common use case is querying period-to-date or project-to-date summarized costs and revenues for a set of projects. For example, a financial analyst might execute a query to retrieve total actual costs by period for a specific project hierarchy. The table is also essential for reconciling project balances with the General Ledger. A typical SQL pattern involves joining PA_SUMM_BALANCES with PA_OBJECTS for descriptive information and GL_PERIOD_SETS for period details:

  • SELECT pob.object_name, psb.period_name, psb.actual_raw_cost FROM pa_summ_balances psb, pa_objects pob WHERE psb.object_id = pob.object_id AND pob.project_id = :p_project_id ORDER BY psb.period_name;

Reports and interfaces often source data from this table to avoid performance degradation associated with directly querying transactional tables like PA_EXPENDITURES_ALL.

Related Objects

PA_SUMM_BALANCES has defined relationships with several key EBS objects, as indicated by its foreign keys. The primary parent table is PA_OBJECTS, which defines all reportable entities in Projects, such as projects, tasks, and top tasks. The table also references GL_PERIOD_SETS, linking it to the enterprise's accounting calendar. While not listed in the excerpt, this summary table is likely populated by or feeds into various Oracle Projects public application programming interfaces (APIs) and is a fundamental source for Oracle Projects standard reports and the Projects Intelligence (PJI) reporting schema. Direct transactional tables like PA_EXPENDITURES_ALL and PA_COST_DISTRIBUTION_ALL are the ultimate sources for the summaries stored here.

  • Table: PA_SUMM_BALANCES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_SUMM_BALANCES,  object_name:PA_SUMM_BALANCES,  status:VALID,  product: PA - Projects ,  description: PA_SUMM_BALANCES stores summarized balance informations for reporting objects. ,  implementation_dba_data: PA.PA_SUMM_BALANCES , 

  • Table: PA_SUMM_BALANCES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_SUMM_BALANCES,  object_name:PA_SUMM_BALANCES,  status:VALID,  product: PA - Projects ,  description: PA_SUMM_BALANCES stores summarized balance informations for reporting objects. ,  implementation_dba_data: PA.PA_SUMM_BALANCES , 

  • Table: PA_OBJECTS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_OBJECTS,  object_name:PA_OBJECTS,  status:VALID,  product: PA - Projects ,  description: PA_OBJECTS stores the reporting objects for which summarized balances are created. ,  implementation_dba_data: PA.PA_OBJECTS , 

  • Table: PA_OBJECTS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_OBJECTS,  object_name:PA_OBJECTS,  status:VALID,  product: PA - Projects ,  description: PA_OBJECTS stores the reporting objects for which summarized balances are created. ,  implementation_dba_data: PA.PA_OBJECTS , 

  • View: PA_REP_UTIL_ACT_RUCR_PA_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_ACT_RUCR_PA_V,  object_name:PA_REP_UTIL_ACT_RUCR_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_ACT_RUCR_PA_V is a view to provide Total Actual Hours value s for Person Resources by utilization category across PA Periods. This informat ion is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_ACT_RUCR_PA_V , 

  • View: PA_REP_UTIL_ACT_RUCR_GE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_ACT_RUCR_GE_V,  object_name:PA_REP_UTIL_ACT_RUCR_GE_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_ACT_RUCR_GE_V is a view to provide Total Actual Hours values for Person Resources by utilization category across Global Week. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_ACT_RUCR_GE_V , 

  • View: PA_REP_UTIL_ACT_RUCR_GL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_ACT_RUCR_GL_V,  object_name:PA_REP_UTIL_ACT_RUCR_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_ACT_RUCR_GL_V is a view to provide Total Actual Hours values for Person Resources by utilization category across GL Periods. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_ACT_RUCR_GL_V , 

  • View: PA_REP_UTIL_ACT_RUCR_GE_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_ACT_RUCR_GE_V,  object_name:PA_REP_UTIL_ACT_RUCR_GE_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_ACT_RUCR_GE_V is a view to provide Total Actual Hours values for Person Resources by utilization category across Global Week. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_ACT_RUCR_GE_V , 

  • View: PA_REP_UTIL_ACT_RUCR_GL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_ACT_RUCR_GL_V,  object_name:PA_REP_UTIL_ACT_RUCR_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_ACT_RUCR_GL_V is a view to provide Total Actual Hours values for Person Resources by utilization category across GL Periods. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_ACT_RUCR_GL_V , 

  • View: PA_REP_UTIL_OWTVW_GE_V 12.2.2

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

  • View: PA_REP_UTIL_ACT_RUCR_PA_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_ACT_RUCR_PA_V,  object_name:PA_REP_UTIL_ACT_RUCR_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_ACT_RUCR_PA_V is a view to provide Total Actual Hours value s for Person Resources by utilization category across PA Periods. This informat ion is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_ACT_RUCR_PA_V , 

  • View: PA_REP_UTIL_FCT_RUCR_GE_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_FCT_RUCR_GE_V,  object_name:PA_REP_UTIL_FCT_RUCR_GE_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_FCT_RUCR_GE_V is a view to provide Forecast Capacity and Total Forecast Hours values for Person Resources by utilization category across Global Week. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_FCT_RUCR_GE_V , 

  • View: PA_REP_UTIL_FCT_RUCR_GE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_FCT_RUCR_GE_V,  object_name:PA_REP_UTIL_FCT_RUCR_GE_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_FCT_RUCR_GE_V is a view to provide Forecast Capacity and Total Forecast Hours values for Person Resources by utilization category across Global Week. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_FCT_RUCR_GE_V , 

  • View: PA_REP_UTIL_OWTVW_PA_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_OWTVW_PA_V,  object_name:PA_REP_UTIL_OWTVW_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_OWTVW_PA_V is a view to provide Total Hours and Total Weighted Hours values for organization/WorkType combinations across PA Period. This information is used by Disco Workbooks. ,  implementation_dba_data: APPS.PA_REP_UTIL_OWTVW_PA_V , 

  • View: PA_REP_UTIL_OWTVW_GL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_OWTVW_GL_V,  object_name:PA_REP_UTIL_OWTVW_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_OWTVW_GL_V is a view to provide Total Hours and Total Weighted Hours values for organization/WorkType combinations across GL Period. This information is used by Disco Workbooks. ,  implementation_dba_data: APPS.PA_REP_UTIL_OWTVW_GL_V , 

  • View: PA_REP_UTIL_OWTVW_GL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_OWTVW_GL_V,  object_name:PA_REP_UTIL_OWTVW_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_OWTVW_GL_V is a view to provide Total Hours and Total Weighted Hours values for organization/WorkType combinations across GL Period. This information is used by Disco Workbooks. ,  implementation_dba_data: APPS.PA_REP_UTIL_OWTVW_GL_V , 

  • View: PA_REP_UTIL_FCT_RUCR_PA_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_FCT_RUCR_PA_V,  object_name:PA_REP_UTIL_FCT_RUCR_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_FCT_RUCR_PA_V is a view to provide Forecast Capacity and Total Forecast Hours values for Person Resources by utilization category across PA Periods. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_FCT_RUCR_PA_V , 

  • View: PA_REP_UTIL_OWTVW_GE_V 12.1.1

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

  • View: PA_REP_UTIL_FCT_RUCR_GL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_FCT_RUCR_GL_V,  object_name:PA_REP_UTIL_FCT_RUCR_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_FCT_RUCR_GL_V is a view to provide Forecast Capacity and Total Forecast Hours values for Person Resources by utilization category across GL Periods. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_FCT_RUCR_GL_V , 

  • View: PA_REP_UTIL_ORGVW_GE_V 12.2.2

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

  • View: PA_REP_UTIL_FCT_RUCR_GL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_FCT_RUCR_GL_V,  object_name:PA_REP_UTIL_FCT_RUCR_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_FCT_RUCR_GL_V is a view to provide Forecast Capacity and Total Forecast Hours values for Person Resources by utilization category across GL Periods. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_FCT_RUCR_GL_V , 

  • View: PA_REP_UTIL_FCT_RUCR_PA_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_FCT_RUCR_PA_V,  object_name:PA_REP_UTIL_FCT_RUCR_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_FCT_RUCR_PA_V is a view to provide Forecast Capacity and Total Forecast Hours values for Person Resources by utilization category across PA Periods. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_FCT_RUCR_PA_V , 

  • View: PA_REP_UTIL_OWTVW_PA_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_OWTVW_PA_V,  object_name:PA_REP_UTIL_OWTVW_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_OWTVW_PA_V is a view to provide Total Hours and Total Weighted Hours values for organization/WorkType combinations across PA Period. This information is used by Disco Workbooks. ,  implementation_dba_data: APPS.PA_REP_UTIL_OWTVW_PA_V , 

  • View: PA_REP_UTIL_ORGVW_GL_V 12.1.1

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

  • View: PA_REP_UTIL_ORGVW_PA_V 12.2.2

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

  • View: PA_REP_UTIL_ORGVW_GE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_ORGVW_GE_V,  object_name:PA_REP_UTIL_ORGVW_GE_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_ORGVW_GE_V is a view to provide Capacity and Total Hours values for organizations across Global Week. This information is used by Disco Workbooks. ,  implementation_dba_data: APPS.PA_REP_UTIL_ORGVW_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_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_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_ORGVW_PA_V 12.1.1

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

  • View: PA_REP_UTIL_ORGVW_GL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_ORGVW_GL_V,  object_name:PA_REP_UTIL_ORGVW_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_ORGVW_GL_V is a view to provide Capacity and Total Hours values for organizations across GL Periods. This information is used by Disco Workbooks. ,  implementation_dba_data: APPS.PA_REP_UTIL_ORGVW_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_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_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_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_UTIL_RWTVW_PA_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_RWTVW_PA_V,  object_name:PA_REP_UTIL_RWTVW_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_RWTVW_PA_V is a view to provide Total Hours and Total Weighted Hours values for resources across PA Periods. This information is used by Disco Workbooks. ,  implementation_dba_data: APPS.PA_REP_UTIL_RWTVW_PA_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_UTIL_RWTVW_GL_V 12.1.1

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

  • View: PA_REP_UTIL_RWTVW_PA_V 12.1.1

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

  • View: PA_REP_UTIL_RWTVW_GL_V 12.2.2

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

  • View: PA_REP_UTIL_ACT_RSUM_PA_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_ACT_RSUM_PA_V,  object_name:PA_REP_UTIL_ACT_RSUM_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_ACT_RSUM_PA_V is a view to provide Actual Capacity and Total Actual Hours values for Person Resources across PA Periods. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_ACT_RSUM_PA_V , 

  • View: PA_REP_UTIL_ACT_RSUM_GE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_ACT_RSUM_GE_V,  object_name:PA_REP_UTIL_ACT_RSUM_GE_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_ACT_RSUM_GE_V is a view to provide Actual Capacity and Total Actual Hours values for Person Resources across Global Week. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_ACT_RSUM_GE_V , 

  • View: PA_REP_UTIL_ACT_RSUM_PA_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_ACT_RSUM_PA_V,  object_name:PA_REP_UTIL_ACT_RSUM_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_ACT_RSUM_PA_V is a view to provide Actual Capacity and Total Actual Hours values for Person Resources across PA Periods. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_ACT_RSUM_PA_V , 

  • View: PA_REP_UTIL_ACT_RSUM_GL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_ACT_RSUM_GL_V,  object_name:PA_REP_UTIL_ACT_RSUM_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_ACT_RSUM_GL_V is a view to provide Actual Capacity and Total Actual Hours values for Person Resources across GL Periods. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_ACT_RSUM_GL_V , 

  • View: PA_REP_UTIL_ACT_RSUM_GE_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_ACT_RSUM_GE_V,  object_name:PA_REP_UTIL_ACT_RSUM_GE_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_ACT_RSUM_GE_V is a view to provide Actual Capacity and Total Actual Hours values for Person Resources across Global Week. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_ACT_RSUM_GE_V , 

  • View: PA_REP_UTIL_ACT_RSUM_GL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_ACT_RSUM_GL_V,  object_name:PA_REP_UTIL_ACT_RSUM_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_ACT_RSUM_GL_V is a view to provide Actual Capacity and Total Actual Hours values for Person Resources across GL Periods. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_ACT_RSUM_GL_V , 

  • View: PA_REP_UTIL_FCT_RSUM_PA_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_FCT_RSUM_PA_V,  object_name:PA_REP_UTIL_FCT_RSUM_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_FCT_RSUM_PA_V is a view to provide Forecast Capacity and Total Forecast Hours values for Person Resources across PA Periods. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_FCT_RSUM_PA_V , 

  • View: PA_REP_UTIL_FCT_RSUM_GL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_FCT_RSUM_GL_V,  object_name:PA_REP_UTIL_FCT_RSUM_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_FCT_RSUM_GL_V is a view to provide Forecast Capacity and Total Forecast Hours values for Person Resources across GL Periods. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_FCT_RSUM_GL_V , 

  • View: PA_REP_UTIL_FCT_RSUM_PA_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_FCT_RSUM_PA_V,  object_name:PA_REP_UTIL_FCT_RSUM_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_FCT_RSUM_PA_V is a view to provide Forecast Capacity and Total Forecast Hours values for Person Resources across PA Periods. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_FCT_RSUM_PA_V , 

  • View: PA_REP_UTIL_FCT_RSUM_GL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_UTIL_FCT_RSUM_GL_V,  object_name:PA_REP_UTIL_FCT_RSUM_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_UTIL_FCT_RSUM_GL_V is a view to provide Forecast Capacity and Total Forecast Hours values for Person Resources across GL Periods. This information is used by OA Screens. ,  implementation_dba_data: APPS.PA_REP_UTIL_FCT_RSUM_GL_V ,