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.PJI_DIS_MGRWT_V

Object Details

Object Name:	PJI_DIS_MGRWT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PJI.PJI_DIS_MGRWT_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Discoverer view of manager work type utilization data.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CAPACITY_HRS	NUMBER			Actual capacity based on resources calendar
RES_TOTAL_HRS	NUMBER			Resource total actual hours
RES_CONF_HRS	NUMBER			Resource confirmed assigned hours
RES_REDUCE_CAP_HRS_A	NUMBER			Resource total actual hours less reduce capacity hours
RES_REDUCE_CAP_HRS_S	NUMBER			Resource schedules hours less reduce capacity hours.
TOTAL_HRS_A	NUMBER			Total actual hours (as per timecards).
BILL_HRS_A	NUMBER			Billable actual hours
CONF_HRS_S	NUMBER			Confirmed assignment hours
PROV_HRS_S	NUMBER			Provisional assignment hours for the resource
CONF_OVERCOM_HRS_S	NUMBER			Confirmed overcommitted hours
PROV_OVERCOM_HRS_S	NUMBER			Provisional overcommitted hours
PERIOD_NAME	VARCHAR2	(119)		Period Name
QUARTER_NAME	VARCHAR2	(100)		Quarter name
YEAR	VARCHAR2	(100)		Year
PERIOD_START_DATE	DATE			Period start date
PERIOD_END_DATE	DATE			Period end date
QUARTER_START_DATE	DATE			Quarter start date
QUARTER_END_DATE	DATE			Quarter end date
YEAR_START_DATE	DATE			Year start date
YEAR_END_DATE	DATE			Year end date
PERIOD_TYPE_ID	NUMBER	(15)		Level of calendar rollup
CALENDAR_TYPE	VARCHAR2	(1)		Specifies the calendar type: 'C' = Common (shared between ENT and GL), 'P' = PA calendar, 'G' = GL calendar, 'E' = Enterprise calendar
TIME_ID	NUMBER	(15)		Time identifier
JOB_ID	NUMBER	(15)		Job identifier
WORK_TYPE_ID	NUMBER			Work Type Identifier
ORGANIZATION_ID	NUMBER	(15)		The identifier of the organization that incurred the charges
EXPENDITURE_ORG_ID	NUMBER	(15)		Operating unit identifier for multi-organization installations of expenditure item
PERIOD_ID	NUMBER			Period Identifier
PERIOD_TYPE	VARCHAR2	(19)		Identifier for the period type: Week, Period, Quarter, Year
QUARTER_ID	NUMBER			Quarter Identifier
YEAR_ID	NUMBER			Year Identifier
CALENDAR_ID	NUMBER			Calendar Identifier
MGR_ABSOLUTE_LEVEL	NUMBER	(15)	Yes	Manager level
PERSON_ABSOLUTE_LEVEL	NUMBER	(15)	Yes	Person level
PERSON_RELATIVE_LEVEL	NUMBER		Yes	Person relative level
MANAGER_ID	NUMBER	(15)	Yes	Manager Identifier
PERSON_ID	NUMBER	(15)	Yes	Person Identifier
SUP_ASSIGNMENT_ID	NUMBER	(15)	Yes	Identifier for supervisor assignment
SUB_ASSIGNMENT_ID	NUMBER	(15)	Yes	Identifier for subordinate assignment
LAST_ACT_EXTR_DATE	NUMBER			Date of last actuals summarization run.
ORG_UTIL_CALC_METH	VARCHAR2	(4000)		Organization utilization calculation method
RES_UTIL_CALC_METH	VARCHAR2	(4000)		Resource utilization calculation method
PERSON_TYPE	VARCHAR2	(30)	Yes	System name for the person type

Query Text

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


SELECT CAPACITY_HRS
,      RES_TOTAL_HRS
,      RES_CONF_HRS
,      RES_REDUCE_CAP_HRS_A
,      RES_REDUCE_CAP_HRS_S
,      TOTAL_HRS_A
,      BILL_HRS_A
,      CONF_HRS_S
,      PROV_HRS_S
,      CONF_OVERCOM_HRS_S
,      PROV_OVERCOM_HRS_S
,      PERIOD_NAME
,      QUARTER_NAME
,      YEAR
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      QUARTER_START_DATE
,      QUARTER_END_DATE
,      YEAR_START_DATE
,      YEAR_END_DATE
,      PERIOD_TYPE_ID
,      CALENDAR_TYPE
,      TIME_ID
,      JOB_ID
,      WORK_TYPE_ID
,      ORGANIZATION_ID
,      EXPENDITURE_ORG_ID
,      PERIOD_ID
,      PERIOD_TYPE
,      QUARTER_ID
,      YEAR_ID
,      CALENDAR_ID
,      MGR_ABSOLUTE_LEVEL
,      PERSON_ABSOLUTE_LEVEL
,      PERSON_RELATIVE_LEVEL
,      MANAGER_ID
,      PERSON_ID
,      SUP_ASSIGNMENT_ID
,      SUB_ASSIGNMENT_ID
,      LAST_ACT_EXTR_DATE
,      ORG_UTIL_CALC_METH
,      RES_UTIL_CALC_METH
,      PERSON_TYPE
FROM APPS.PJI_DIS_MGRWT_V;

Dependencies

[top of page]

APPS.PJI_DIS_MGRWT_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_PROFILE - show dependent code; HRI_CS_SUPH_V; PA_WORK_TYPES_B; PER_PERSON_TYPES; PER_PERSON_TYPE_USAGES_F; PJI_ORG_EXTR_INFO; PJI_RM_RES_F; PJI_RM_RES_WT_F; PJI_TIME_DAY_MV; PJI_UTILS - show dependent code
PUBLIC: DUAL

APPS.PJI_DIS_MGRWT_V is not referenced by any database object