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_WORK_TYPES_V

Object Details

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

View Type

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

Discoverer view of work type data.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BILLABLE_CAPITALIZABLE_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether the work type is billable or capitalizable.
WORKTYPE	VARCHAR2	(80)	Yes	Identifier of the work type.
ORG_UTIL_CATEGORY_ID	NUMBER			Organization utilization category for the work type.
ORG_UTILIZATION_PERCENTAGE	NUMBER		Yes	Organization utilization percentage for the work type.
REDUCE_CAPACITY_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether any hours charged by the resource to this work type will reduce the capacity of the resource and the appropriate organization.
RES_UTIL_CATEGORY_ID	NUMBER			Resource utilization category for the work type.
RES_UTILIZATION_PERCENTAGE	NUMBER		Yes	Resource utilization percentage for the work type.
TRAINING_FLAG	VARCHAR2	(1)		This flag indicates if the work type is training category.
UNASSIGNED_FLAG	VARCHAR2	(1)		Unassigned work type flag
WORK_TYPE_ID	NUMBER		Yes	The system generated number that uniquely identifies the work type.
ORG_UTILIZATION_CATEGORY	VARCHAR2	(80)	Yes	Organization utilization category for the work type.
RES_UTILIZATION_CATEGORY	VARCHAR2	(80)	Yes	Resource utilization category for the work type.

Query Text

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


SELECT BILLABLE_CAPITALIZABLE_FLAG
,      WORKTYPE
,      ORG_UTIL_CATEGORY_ID
,      ORG_UTILIZATION_PERCENTAGE
,      REDUCE_CAPACITY_FLAG
,      RES_UTIL_CATEGORY_ID
,      RES_UTILIZATION_PERCENTAGE
,      TRAINING_FLAG
,      UNASSIGNED_FLAG
,      WORK_TYPE_ID
,      ORG_UTILIZATION_CATEGORY
,      RES_UTILIZATION_CATEGORY
FROM APPS.PJI_DIS_WORK_TYPES_V;

Dependencies

[top of page]

APPS.PJI_DIS_WORK_TYPES_V references the following:

APPS: PA_UTIL_CATEGORIES_B; PA_UTIL_CATEGORIES_TL; PA_WORK_TYPES_B; PA_WORK_TYPES_TL

APPS.PJI_DIS_WORK_TYPES_V is not referenced by any database object