eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PA_REP_UTIL_ORG_PA_V

Object Details

Object Name:	PA_REP_UTIL_ORG_PA_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TITLE_NAME	VARCHAR2	(80)
TITLE_CODE	VARCHAR2	(30)		Identifier of the Expenditure Organization level atttribute.
EXP_ORGANIZATION_ID	NUMBER		Yes	Internal Identifier of the Expenditure Organization.
EXP_SUB_ORGANIZATION_ID	NUMBER		Yes	Internal Identifier of the Sub-Expenditure Organization.
EXP_SUB_ORGANIZATION_NAME	VARCHAR2	(240)		Language Specific name of the Sub-Expenditure Organization.
EMP_HEAD_COUNT	NUMBER			Total number of employees for the Organization.
OTHERS_HEAD_COUNT	NUMBER			Total number of non-employees for the Organization.
ACTUALS_CAPACITY	NUMBER			The Actual Capacity of the Organization after taking into consideration the reduced capacity
ACTUALS_HOURS	NUMBER			The Total Actual Hours of the Organization.
ACTUALS_WEIGHTED_HOURS	NUMBER			The Total Actual Hours of the Organization weighted by the Organization Utilization Categories.
ACTUALS_UTILIZATION	NUMBER			The Actual Utilization Percentage for the Organization
FORECAST_CAPACITY	NUMBER			The Forecast Capacity of the Organization after taking into consideration the reduced capacity
FORECAST_HOURS	NUMBER			The Total Forecast Hours of the Organization.
FORECAST_WEIGHTED_HOURS	NUMBER			The Total Forecast Hours of the Organization weighted by the Organization Utilization Categories.
FORECAST_UTILIZATION	NUMBER			The Forecast Utilization percentage for the Organization
PERIOD_SET_NAME	VARCHAR2	(15)		The period set to which the GL period.
PERIOD_YEAR	NUMBER			The year to which the Global week belongs.
PERIOD_QUARTER	NUMBER			The Quarter Number to which the PA Period belongs.
PERIOD_NAME	VARCHAR2	(15)	Yes	The name of the PA period.
PERIOD_NUM	NUMBER			The Effective Period Number of the PA Period.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TITLE_NAME
,      TITLE_CODE
,      EXP_ORGANIZATION_ID
,      EXP_SUB_ORGANIZATION_ID
,      EXP_SUB_ORGANIZATION_NAME
,      EMP_HEAD_COUNT
,      OTHERS_HEAD_COUNT
,      ACTUALS_CAPACITY
,      ACTUALS_HOURS
,      ACTUALS_WEIGHTED_HOURS
,      ACTUALS_UTILIZATION
,      FORECAST_CAPACITY
,      FORECAST_HOURS
,      FORECAST_WEIGHTED_HOURS
,      FORECAST_UTILIZATION
,      PERIOD_SET_NAME
,      PERIOD_YEAR
,      PERIOD_QUARTER
,      PERIOD_NAME
,      PERIOD_NUM
FROM APPS.PA_REP_UTIL_ORG_PA_V;