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

VIEW: APPS.PA_REP_UTIL_ACT_RSUM_PA_V

Object Details
Object Name: PA_REP_UTIL_ACT_RSUM_PA_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_REP_UTIL_ACT_RSUM_PA_V
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_CODE VARCHAR2 (80) Yes Identifier of the aggregation level - Period, Quarter or Year.
PERSON_ID NUMBER
Yes Internal Identifier of the Person Resource.
CAPACITY NUMBER

The Capacity of the Person Resource after taking into consideration the reduced capacity.
WORKED_HOURS NUMBER

The Total Actual Hours of the Person Resource.
UTILIZATION NUMBER

The Total Actual Hours of the Person Resource weighted by the Resource Utilization Categories.
Query Text

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


SELECT TITLE_CODE
,      PERSON_ID
,      CAPACITY
,      WORKED_HOURS
,      UTILIZATION
FROM APPS.PA_REP_UTIL_ACT_RSUM_PA_V;

Dependencies

[top of page]

APPS.PA_REP_UTIL_ACT_RSUM_PA_V references the following:

SchemaAPPS
ViewPA_LOOKUPS
SynonymPA_OBJECTS
PL/SQL PackagePA_REP_UTIL_GLOB - show dependent code
SynonymPA_SUMM_BALANCES
SchemaPUBLIC
SynonymDUAL

APPS.PA_REP_UTIL_ACT_RSUM_PA_V is not referenced by any database object