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_PLANNING_CRITERIA_B

Object Details

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

Criteria used in planning a wave in Wave Planning

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
PLANNING_CRITERIA_ID	NUMBER		Yes	planning criteria id
PLANNING_METHOD	VARCHAR2	(200)		planning method
TYPE	VARCHAR2	(1)		planning type
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			last update login
BACKORDER_FLAG	VARCHAR2	(1)		backorder flag
REJECT_ORDER_LINE_FLAG	VARCHAR2	(1)		reject order line flag
REJECT_ALL_LINES_SHIPSET_FLAG	VARCHAR2	(1)		reject all lines in shipset flag
REJECT_ALL_LINES_MODEL_FLAG	VARCHAR2	(1)		reject all lines in model flag
REJECT_ORDER_FLAG	VARCHAR2	(1)		reject order flag
RESERVE_STOCK_FLAG	VARCHAR2	(1)		reserve stock flag
AUTO_CREATE_DELIVERIES_FLAG	VARCHAR2	(1)		autocreate deliveries flag
CREDIT_CHECK_HOLD_FLAG	VARCHAR2	(1)		credit check hold flag
PICKING_SUBINVENTORY	VARCHAR2	(30)		picking subinventory
DESTINATION_SUBINVENTORY	VARCHAR2	(30)		destination subinventory
BULK_LABOR_PLANNING_FLAG	VARCHAR2	(1)		bulk labor planning flag
TIME_UOM	VARCHAR2	(3)		time uom
DEPARTMENT_CODE	VARCHAR2	(100)		department code
DEPARTMENT_ID	NUMBER			department id
ENABLE_LABOR_PLANNING	VARCHAR2	(1)		flag if labor planning is enabled
CROSSDOCK_CRITERIA	VARCHAR2	(100)		crossdock criteria
CROSSDOCK_CRITERIA_ID	NUMBER			id of crossdock criteria
ALLOCATION_METHOD	VARCHAR2	(1)		allocation method
LABOR_SETUP_MODE	VARCHAR2	(1)		labor setup mode

Query Text

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


SELECT PLANNING_CRITERIA_ID
,      PLANNING_METHOD
,      TYPE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      BACKORDER_FLAG
,      REJECT_ORDER_LINE_FLAG
,      REJECT_ALL_LINES_SHIPSET_FLAG
,      REJECT_ALL_LINES_MODEL_FLAG
,      REJECT_ORDER_FLAG
,      RESERVE_STOCK_FLAG
,      AUTO_CREATE_DELIVERIES_FLAG
,      CREDIT_CHECK_HOLD_FLAG
,      PICKING_SUBINVENTORY
,      DESTINATION_SUBINVENTORY
,      BULK_LABOR_PLANNING_FLAG
,      TIME_UOM
,      DEPARTMENT_CODE
,      DEPARTMENT_ID
,      ENABLE_LABOR_PLANNING
,      CROSSDOCK_CRITERIA
,      CROSSDOCK_CRITERIA_ID
,      ALLOCATION_METHOD
,      LABOR_SETUP_MODE
FROM WMS.WMS_WP_PLANNING_CRITERIA_B;

Dependencies

[top of page]

WMS.WMS_WP_PLANNING_CRITERIA_B does not reference any database object

WMS.WMS_WP_PLANNING_CRITERIA_B is referenced by following:

WMS: WMS_WP_PLANNING_CRITERIA_B#