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

TYPE: APPS.PJI_REP_U1

Object Details
Object Name: PJI_REP_U1
Object Type: TYPE
Owner: APPS
Subobject Name:
Status: VALID
Type Details
Type Code: OBJECT
Predefined: NO
Incomplete: NO
Attributes
Name Datatype Length Prcn
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)
ACTUAL_CAPACITY_HOURS NUMBER

MISSING_HOURS NUMBER

ACTUAL_UTIL_HOURS NUMBER

BILLABLE_HOURS NUMBER

SCHEDULED_UTIL_HOURS NUMBER

SCHEDULED_CAPACITY_HOURS NUMBER

RESOURCE_HOURS NUMBER

TOTAL_RESOURCE_HOURS NUMBER

ACTUAL_DENOMINATOR NUMBER

SCHEDULED_DENOMINATOR NUMBER

PRIOR_ACTUAL_CAPACITY_HOURS NUMBER

PRIOR_MISSING_HOURS NUMBER

PRIOR_ACTUAL_UTIL_HOURS NUMBER

PRIOR_BILLABLE_HOURS NUMBER

PRIOR_SCH_UTIL_HOURS NUMBER

PRIOR_SCH_CAPACITY_HOURS NUMBER

PRIOR_RESOURCE_HOURS NUMBER

PRIOR_TOTAL_RESOURCE_HOURS NUMBER

PRIOR_ACTUAL_DENOMINATOR NUMBER

PRIOR_SCHEDULED_DENOMINATOR NUMBER

BILL_HOURS_PERCENT NUMBER

PRIOR_BILL_HOURS_PERCENT NUMBER

ACT_UTIL_PERCENT NUMBER

PRIOR_ACT_UTIL_PERCENT NUMBER

RES_HOURS_PERCENT NUMBER

PRIOR_RES_HOURS_PERCENT NUMBER

CHANGE_PERCENT_1 NUMBER

CHANGE_PERCENT_2 NUMBER

CHANGE_PERCENT_3 NUMBER

SCH_UTIL_PERCENT NUMBER

MISSING_HOURS_PERCENT NUMBER

SCH_VAR_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

Dependencies

[top of page]

APPS.PJI_REP_U1 references the following:

SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
APPS.PJI_REP_U1 is referenced by following:

SchemaAPPS
Package BodyPJI_PMV_UTLZ - show dependent code
TYPEPJI_REP_U1_TBL