Skip to content

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

TABLE: WMS.WMS_WP_LABOR_PLANNING

Object Details
Object Name: WMS_WP_LABOR_PLANNING
Object Type: TABLE
Owner: WMS
Subobject Name:
Status: VALID


Stores labor planning setups used in Wave Planning.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LABOR_PLANNING_ID NUMBER
Yes labor planning id
PLANNING_CRITERIA_ID NUMBER
Yes planning criteria id
LAST_UPDATED_BY NUMBER
Yes last updated by
LAST_UPDATE_DATE DATE
Yes last update date
CREATED_BY NUMBER
Yes created by
CREATION_DATE DATE
Yes creation date
LAST_UPDATE_LOGIN NUMBER
Yes last update login
SOURCE_SUBINVENTORY VARCHAR2 (30) Yes source subinventory
DESTINATION_SUBINVENTORY VARCHAR2 (30) Yes destination subinventory
PICK_UOM VARCHAR2 (3) Yes pick uom
RESOURCE_TYPE VARCHAR2 (10) Yes resource type
TRANSACTION_TIME NUMBER

transaction time
TRAVEL_TIME NUMBER

travel time
ITEM_CATEGORY_NAME VARCHAR2 (100)
item category name
CATEGORY_ID NUMBER

category id
OPERATION_PLAN_ID NUMBER

operation plan id
PROCESSING_OVERHEAD_DURATION NUMBER

processing overhead duration
SOURCE_TYPE VARCHAR2 (15)
source type
Query Text

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


SELECT LABOR_PLANNING_ID
,      PLANNING_CRITERIA_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      SOURCE_SUBINVENTORY
,      DESTINATION_SUBINVENTORY
,      PICK_UOM
,      RESOURCE_TYPE
,      TRANSACTION_TIME
,      TRAVEL_TIME
,      ITEM_CATEGORY_NAME
,      CATEGORY_ID
,      OPERATION_PLAN_ID
,      PROCESSING_OVERHEAD_DURATION
,      SOURCE_TYPE
FROM WMS.WMS_WP_LABOR_PLANNING;

Dependencies

[top of page]

WMS.WMS_WP_LABOR_PLANNING does not reference any database object

WMS.WMS_WP_LABOR_PLANNING is referenced by following:

SchemaWMS
ViewWMS_WP_LABOR_PLANNING#