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


VIEW: APPS.PA_REP_UTIL_ORG_GL_V

Object Details
Object Name: PA_REP_UTIL_ORG_GL_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 GL Period belongs.
PERIOD_NAME VARCHAR2 (15) Yes The name of the GL period.
PERIOD_NUM NUMBER

The Effective Period Number of the GL 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_GL_V;

Dependencies

[top of page]

APPS.PA_REP_UTIL_ORG_GL_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORG_UNITS_NO_JOIN
PL/SQL PackageHR_SECURITY - show dependent code
ViewPA_LOOKUPS
SynonymPA_OBJECTS
SynonymPA_ORG_HIERARCHY_DENORM
PL/SQL PackagePA_REP_UTIL_GLOB - show dependent code
PL/SQL PackagePA_RESOURCE_UTILS - show dependent code
SynonymPA_SUMM_BALANCES
APPS.PA_REP_UTIL_ORG_GL_V is referenced by following:

SchemaAPPS
Package BodyPA_REP_UTIL_SCREEN - show dependent code