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]

TYPE: APPS.PJI_REP_U4

Object Details

Object Name:	PJI_REP_U4
Object Type:	TYPE
Owner:	APPS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length
ORG_ID	VARCHAR2	(240)
ORGANIZATION_ID	VARCHAR2	(240)
TIME_ID	VARCHAR2	(150)
TIME_KEY	NUMBER
UTIL_CATEGORY_ID	VARCHAR2	(150)
WORK_TYPE_ID	VARCHAR2	(150)
JOB_LEVEL_ID	VARCHAR2	(150)
SCHEDULED_HOURS	NUMBER
SCHEDULED_CAPACITY_HOURS	NUMBER
SCHEDULED_UTIL_HOURS	NUMBER
PROVISIONAL_HOURS	NUMBER
UNASSIGNED_HOURS	NUMBER
CONF_BILLABLE_HOURS	NUMBER
CONF_NONBILLABLE_HOURS	NUMBER
PROV_BILLABLE_HOURS	NUMBER
PROV_NONBILLABLE_HOURS	NUMBER
TRAINING_HOURS	NUMBER
EXPECTED_HOURS	NUMBER
EXPECTED_UTIL_HOURS	NUMBER
EXPECTED_TOTAL_UTIL_HOURS	NUMBER
ACTUAL_UTIL_HOURS	NUMBER
ACTUAL_CAPACITY_HOURS	NUMBER
EXPECTED_CAPACITY_HOURS	NUMBER
PROV_UTIL_HOURS	NUMBER
EXP_AC_UTIL_HOURS	NUMBER
EXP_SCH_UTIL_HOURS	NUMBER
EXP_AC_DENOMINATOR	NUMBER
EXP_SCH_DENOMINATOR	NUMBER
ACTUAL_DENOMINATOR	NUMBER
SCHEDULED_DENOMINATOR	NUMBER
EXPECTED_DENOMINATOR	NUMBER
PRIOR_SCHEDULED_HOURS	NUMBER
PRIOR_SCH_CAPACITY_HOURS	NUMBER
PRIOR_SCH_UTIL_HOURS	NUMBER
PRIOR_CONF_BILLABLE_HOURS	NUMBER
PRIOR_CONF_NONBILLABLE_HOURS	NUMBER
PRIOR_ACTUAL_CAPACITY_HOURS	NUMBER
PRIOR_ACTUAL_UTIL_HOURS	NUMBER
PRIOR_ACTUAL_DENOMINATOR	NUMBER
PRIOR_SCHEDULED_DENOMINATOR	NUMBER
SCH_UTIL_PERCENT	NUMBER
BILL_UTIL_PERCENT	NUMBER
NONBILL_UTIL_PERCENT	NUMBER
UNASSIGNED_PERCENT	NUMBER
TRAINING_PERCENT	NUMBER
PROV_BILL_PERCENT	NUMBER
PROV_NONBILL_PERCENT	NUMBER
PRIOR_SCH_UTIL_PERCENT	NUMBER
PRIOR_BILL_UTIL_PERCENT	NUMBER
PRIOR_NONBILL_UTIL_PERCENT	NUMBER
EXP_ACT_UTIL_PERCENT	NUMBER
EXP_SCH_UTIL_PERCENT	NUMBER
EXP_UTIL_PERCENT	NUMBER
PROV_SCH_UTIL_PERCENT	NUMBER
EXP_TOTAL_UTIL_PERCENT	NUMBER
PRIOR_ACT_UTIL_PERCENT	NUMBER
PJI_REP_TOTAL_1	NUMBER
PJI_REP_TOTAL_2	NUMBER
PJI_REP_TOTAL_3	NUMBER
PJI_REP_TOTAL_4	NUMBER
PJI_REP_TOTAL_5	NUMBER
PJI_REP_TOTAL_6	NUMBER
PJI_REP_TOTAL_7	NUMBER
PJI_REP_TOTAL_8	NUMBER
PJI_REP_TOTAL_9	NUMBER
PJI_REP_TOTAL_10	NUMBER
PJI_REP_TOTAL_11	NUMBER
PJI_REP_TOTAL_12	NUMBER
PJI_REP_TOTAL_13	NUMBER
PJI_REP_TOTAL_14	NUMBER
PJI_REP_TOTAL_15	NUMBER
PJI_REP_TOTAL_16	NUMBER
PJI_REP_TOTAL_17	NUMBER
PJI_REP_TOTAL_18	NUMBER
PJI_REP_TOTAL_19	NUMBER
PJI_REP_TOTAL_20	NUMBER
PJI_REP_TOTAL_21	NUMBER
PJI_REP_TOTAL_22	NUMBER
PJI_REP_TOTAL_23	NUMBER

Dependencies

[top of page]

APPS.PJI_REP_U4 references the following:

SYS: STANDARD - show dependent code

APPS.PJI_REP_U4 is referenced by following:

APPS: PJI_PMV_UTLZ - show dependent code; PJI_REP_U4_TBL