[Home] [Help] [Dependency Information]
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 |
A public view which may be useful for custom reporting or other data
requirements.
Discoverer view of work type data.
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. |
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;
APPS.PJI_DIS_WORK_TYPES_V is not referenced by any database object
|
|
|