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]

TABLE: WMS.WMS_WP_LABOR_STATISTICS

Object Details

Object Name:	WMS_WP_LABOR_STATISTICS
Object Type:	TABLE
Owner:	WMS
Subobject Name:
Status:	VALID

Stores statistics used in labor planning.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
WAVE_HEADER_ID	NUMBER		Yes	wave header id
RESOURCE_NAME	VARCHAR2	(100)		resource name
NUMBER_OF_ACTUAL_TASKS	NUMBER			number of actual tasks
NUMBER_OF_PLANNED_TASKS	NUMBER			number of planned tasks
ACTUAL_WORKLOAD	NUMBER			actual workload
PLANNED_WAVE_LOAD	NUMBER			planned wave load
AVAILABLE_CAPACITY	NUMBER			available capacity
TOTAL_CAPACITY	NUMBER			total capacity

Query Text

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


SELECT WAVE_HEADER_ID
,      RESOURCE_NAME
,      NUMBER_OF_ACTUAL_TASKS
,      NUMBER_OF_PLANNED_TASKS
,      ACTUAL_WORKLOAD
,      PLANNED_WAVE_LOAD
,      AVAILABLE_CAPACITY
,      TOTAL_CAPACITY
FROM WMS.WMS_WP_LABOR_STATISTICS;

Dependencies

[top of page]

WMS.WMS_WP_LABOR_STATISTICS does not reference any database object

WMS.WMS_WP_LABOR_STATISTICS is referenced by following:

WMS: WMS_WP_LABOR_STATISTICS#