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_ORGJOB_V

Object Details

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

View Type

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

Discoverer view of organization job utilization data.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CAPACITY_HRS	NUMBER			Actual capacity based on resources calendar.
TOTAL_HRS_A	NUMBER			Total actual hours (as per timecards)
MISSING_HRS_A	NUMBER			Capacity hours less total hours
TOTAL_WTD_ORG_HRS_A	NUMBER			Total actual weighted organization hours.
TOTAL_WTD_RES_HRS_A	NUMBER			Total actual weighted resource hours.
BILL_HRS_A	NUMBER			Billable actual hours
BILL_WTD_ORG_HRS_A	NUMBER			Billable actual weighted organization hours
BILL_WTD_RES_HRS_A	NUMBER			Billable actual weighted resource hours
TRAINING_HRS_A	NUMBER			Total hours that have work type as training.
UNASSIGNED_HRS_A	NUMBER			Actual unassigned hours
REDUCE_CAPACITY_HRS_A	NUMBER			Capacity hours less actual reduce capacity hours.
CONF_HRS_S	NUMBER			Confirmed assignment hours
CONF_WTD_ORG_HRS_S	NUMBER			Confirmed assignment hours by organization.
CONF_WTD_RES_HRS_S	NUMBER			Confirmed assignment hours by resource.
CONF_BILL_HRS_S	NUMBER			Confirmed billable hours
CONF_BILL_WTD_ORG_HRS_S	NUMBER			Confirmed billable weighted organization hours
CONF_BILL_WTD_RES_HRS_S	NUMBER			Confirmed billable weighted resource hours
PROV_HRS_S	NUMBER			Provisional assignment hours for the resource.
PROV_WTD_ORG_HRS_S	NUMBER			Provisional weighted organization hours
PROV_WTD_RES_HRS_S	NUMBER			Provisional weighted resource hours
PROV_BILL_HRS_S	NUMBER			Provisional billable hours
PROV_BILL_WTD_ORG_HRS_S	NUMBER			Provisional billable weighted organization hours
PROV_BILL_WTD_RES_HRS_S	NUMBER			Provisional billable weighted resource hours
TRAINING_HRS_S	NUMBER			Scheduled training hours
UNASSIGNED_HRS_S	NUMBER			Scheduled unassigned hours
REDUCE_CAPACITY_HRS_S	NUMBER			Scheduled reduced capacity hours
CONF_OVERCOM_HRS_S	NUMBER			Confirmed over committed hours
PROV_OVERCOM_HRS_S	NUMBER			Provisional over committed hours
AVAILABLE_HRS_BKT1_S	NUMBER			Bucket 1 hours available
AVAILABLE_HRS_BKT2_S	NUMBER			Bucket 2 hours available
AVAILABLE_HRS_BKT3_S	NUMBER			Bucket 3 hours available
AVAILABLE_HRS_BKT4_S	NUMBER			Bucket 4 hours available
AVAILABLE_HRS_BKT5_S	NUMBER			Bucket 5 hours available
AVAILABLE_RES_COUNT_BKT1_S	NUMBER			Resources available as per bucket 1
AVAILABLE_RES_COUNT_BKT2_S	NUMBER			Resources available as per bucket 2
AVAILABLE_RES_COUNT_BKT3_S	NUMBER			Resources available as per bucket 3
AVAILABLE_RES_COUNT_BKT4_S	NUMBER			Resources available as per bucket 4
AVAILABLE_RES_COUNT_BKT5_S	NUMBER			Resources available as per bucket 5
TOTAL_RES_COUNT	NUMBER			Total resource count
PERIOD_NAME	VARCHAR2	(100)		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)	Yes	Level of calendar rollup
CALENDAR_TYPE	VARCHAR2	(1)	Yes	Type of calendar
TIME_ID	NUMBER	(15)	Yes	Time identifier
JOB_ID	NUMBER	(15)	Yes	Job identifier
ORGANIZATION_ID	NUMBER			The identifier of the organization that incurred the charges.
SUB_ORGANIZATION_ID	NUMBER			Identifier for subordinate organization.
ORGANIZATION_LEVEL	NUMBER			Level of organization
SUB_ORGANIZATION_LEVEL	NUMBER			Level of subordinate organization
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Organization name
SUB_ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Subordinate organization name
EXPENDITURE_ORG_ID	NUMBER	(15)		Operating unit identifier for multi-organization installations of expenditure item.
PERIOD_ID	NUMBER			Identifier for the period.
PERIOD_TYPE	VARCHAR2	(19)		Identifier for the period type.
QUARTER_ID	NUMBER			Identifier for the quarter.
YEAR_ID	NUMBER			Identifier for the year.
CALENDAR_ID	NUMBER			Identifier for the calendar.
LAST_ACT_EXTR_DATE	NUMBER			Date of last actuals summarization run.
ORG_UTIL_CALC_METH	VARCHAR2	(4000)		Organization utilization calculated method
RES_UTIL_CALC_METH	VARCHAR2	(4000)		Resource utilization calculated method

Query Text

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


SELECT CAPACITY_HRS
,      TOTAL_HRS_A
,      MISSING_HRS_A
,      TOTAL_WTD_ORG_HRS_A
,      TOTAL_WTD_RES_HRS_A
,      BILL_HRS_A
,      BILL_WTD_ORG_HRS_A
,      BILL_WTD_RES_HRS_A
,      TRAINING_HRS_A
,      UNASSIGNED_HRS_A
,      REDUCE_CAPACITY_HRS_A
,      CONF_HRS_S
,      CONF_WTD_ORG_HRS_S
,      CONF_WTD_RES_HRS_S
,      CONF_BILL_HRS_S
,      CONF_BILL_WTD_ORG_HRS_S
,      CONF_BILL_WTD_RES_HRS_S
,      PROV_HRS_S
,      PROV_WTD_ORG_HRS_S
,      PROV_WTD_RES_HRS_S
,      PROV_BILL_HRS_S
,      PROV_BILL_WTD_ORG_HRS_S
,      PROV_BILL_WTD_RES_HRS_S
,      TRAINING_HRS_S
,      UNASSIGNED_HRS_S
,      REDUCE_CAPACITY_HRS_S
,      CONF_OVERCOM_HRS_S
,      PROV_OVERCOM_HRS_S
,      AVAILABLE_HRS_BKT1_S
,      AVAILABLE_HRS_BKT2_S
,      AVAILABLE_HRS_BKT3_S
,      AVAILABLE_HRS_BKT4_S
,      AVAILABLE_HRS_BKT5_S
,      AVAILABLE_RES_COUNT_BKT1_S
,      AVAILABLE_RES_COUNT_BKT2_S
,      AVAILABLE_RES_COUNT_BKT3_S
,      AVAILABLE_RES_COUNT_BKT4_S
,      AVAILABLE_RES_COUNT_BKT5_S
,      TOTAL_RES_COUNT
,      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
,      ORGANIZATION_ID
,      SUB_ORGANIZATION_ID
,      ORGANIZATION_LEVEL
,      SUB_ORGANIZATION_LEVEL
,      ORGANIZATION_NAME
,      SUB_ORGANIZATION_NAME
,      EXPENDITURE_ORG_ID
,      PERIOD_ID
,      PERIOD_TYPE
,      QUARTER_ID
,      YEAR_ID
,      CALENDAR_ID
,      LAST_ACT_EXTR_DATE
,      ORG_UTIL_CALC_METH
,      RES_UTIL_CALC_METH
FROM APPS.PJI_DIS_ORGJOB_V;

Dependencies

[top of page]

APPS.PJI_DIS_ORGJOB_V references the following:

APPS: FND_PROFILE - show dependent code; HR_ALL_ORGANIZATION_UNITS_TL; PJI_ORG_DENORM; PJI_ORG_EXTR_INFO; PJI_PMV_ORGZ_DIM_TMP; PJI_PMV_ORG_DIM_TMP; PJI_RM_JOB_F_MV; PJI_TIME_MV; PJI_UTILS - show dependent code
PUBLIC: DUAL

APPS.PJI_DIS_ORGJOB_V is not referenced by any database object