WMS Views (96)

WMS - Warehouse Management — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`WMS_ACCESS_RULES_LOV_V`	WMS accessable rules LOV view
`WMS_ACTIVE_EXCEPTIONS_V`
`WMS_ACTIVE_TASKS_V`
`WMS_BUS_EVENT_DEVICES_V`
`WMS_COMPLETED_EXCEPTIONS_V`
`WMS_COMPLETED_TASKS_V`
`WMS_COST_GROUPS_INPUT_V`	This view joins MTL_TXN_REQUEST_LINES with MTL_MATERIAL_TRANSACTIONS_TEMP. A record from WMS_COST_GROUP_INPUT_V serves as the input for the
`WMS_CROSSDOCK_CRITERIA_VL`	This view represents the MLS database entity WMS_CROSSDOCK_CRITERIA.
`WMS_DEPTS_V`	View of existing departments
`WMS_DEPT_SUBINVENTORIES_V`	View for the WMS_Department_Subinventories table
`WMS_DEVICES_VL`	This view represents the MLS database entity WMS_DEVICES.
`WMS_DEVICE_REQUESTS_HIST_V`	Device Request History. It is used for View Device Request History form
`WMS_DEVICE_REQUESTS_WCSV`	View on which device request query and device response query can be based
`WMS_DISPATCHABLE_TASKS_V`	Dispachable tasks within the warehouse, used by task dispatching engine
`WMS_DOCKS_V`	Not Used
`WMS_DOCK_APPOINTMENTS_V`	Used by WMS dock appointment form.
`WMS_ELS_GROUPED_TASKS_VL`	This view represents the MLS database entity WMS_ELS_GROUPED_TASKS
`WMS_ELS_INDIVIDUAL_TASKS_VL`	This view represents the MLS database entity WMS_ELS_INDIVIDUAL_TASKS
`WMS_EXCEPTIONS_V`	View to capture task exceptions for control board.
`WMS_ITEM_LOCATIONS_KFV`	Dummy view for Mobile Locator KFF
`WMS_LABEL_FIELDS_VL`	This view represents the MLS database entity WMS_LABEL_FIELDS.
`WMS_LABEL_FIELD_VARIABLES_VL`	This view represents the MLS database entity WMS_LABEL_FIELD_VARIABLES.
`WMS_LABEL_FORMATS_V`	This view serves as a base table for the LABELS_FORMATS block in WMSLABEL.fmb (starting version 115.3) replacing WMS_LABEL_V
`WMS_LABEL_REQUESTS_HIST_V`	View to store lable printing request history records
`WMS_LABEL_SET_FORMATS_V`	Stores information about set and format
`WMS_LICENSE_PLATE_NUMBERS_V`	Detailed view of WMS_LICENSE_PLATE_NUMBERS, including detailed information on relations between lpns
`WMS_LOADED_QUANTITIES_V`	This table shows the information for the quantity loaded in the lpn
`WMS_LPN_CONTENTS_DETAIL_V`	View of container contents ( includes detail lot and serial controlled items)
`WMS_LPN_CONTENTS_LOT_V`	View of container contents ( only lot controlled items)
`WMS_LPN_CONTENTS_SERIAL_V`	View of container contents ( only serial controlled items)
`WMS_LPN_CONTENTS_V`	Summary view of container contents ( includes summary of lot and serialized controlled items )
`WMS_OBJECTS_HIERARCHY_LOV_V`	WMS strategy search order LOV view
`WMS_OBJECTS_OPERAND_LOV_V`	WMS restriction right operand LOV view
`WMS_OBJECTS_RULE_LOV_V`	WMS business object LOV view
`WMS_OBJECTS_STRATEGY_LOV_V`	WMS business object available for strategy assignment LOV view
`WMS_OBJECTS_STRATEGY_V`	WMS business object with strategy assigned LOV view
`WMS_OBJECTS_VL`	WMS business object MLS view
`WMS_ONHAND_AND_LOADED_QTY_V`	This view is an union between the onhand quantities table and all material that has been loaded on to an equipment (everything that is in tr
`WMS_OP_PLANS_V`	Header level Operation Plan Information. This view is used in the Operation Plan definition form WMSOPDFN.fmb
`WMS_OP_PLANS_VL`	Header level Operation Plan Information
`WMS_OP_PLAN_DETAILS_V`	Detail level Operation Information
`WMS_ORG_HIERARCHY_OBJS_V`	WMS search order view
`WMS_PACKING_KITTING_V`	View to be used for Packing Workbench Kitting spreadtable
`WMS_PACKING_LPN_CONT_V`	View to display To LPN Content in WMS Packing Workbench Form
`WMS_PACKING_MATERIAL_V`	View to be used for Packing Workbench eligible material spreadtable
`WMS_PAGE_CONFIG_UI_V`	This view shows multilingual information for the WMS page configuration
`WMS_PAGE_FIELDS_VL`
`WMS_PAGE_TEMPLATES_FIELDS_F_V`	This view shows page template fields with configurable fields
`WMS_PAGE_TEMPLATES_VL`
`WMS_PARAMETERS_LOV_V`	WMS parameter LOV view
`WMS_PARAMETERS_VL`	WMS parameter MLS view
`WMS_PENDING_EXCEPTIONS_V`
`WMS_PENDING_TASKS_V`
`WMS_PERSON_RESOURCE_UTT_V`	Relationship of standard_operation_id and resource instances. Used by task dispatching engine.
`WMS_RESTRICTIONS_V`	WMS restriction view
`WMS_RULES_V`	WMS rule view
`WMS_RULES_VL`	WMS rule MLS view
`WMS_RULE_CONSISTENCIES_V`	WMS Rule Consistencies view
`WMS_SELECTION_CRITERIA_TXN_V`	This view shows information about the selection criteria for WMS Rules
`WMS_SHIP_TO_SITES_V`	Customer Ship to Site
`WMS_SORT_CRITERIA_V`	WMS sort criteria view
`WMS_STAGINGLANES_ASSIGNMENTS_V`	View based on the wms_staginglanes_assignments table.
`WMS_STRATEGIES_V`	WMS strategy view
`WMS_STRATEGIES_VL`	WMS strategy MLS view
`WMS_STRATEGY_ASSIGNMENTS_V`	WMS strategy assignment view
`WMS_STRATEGY_ASSIGNMENTS_V2`	WMS strategy assignment view
`WMS_STRATEGY_MAT_TXN_TMP_V`	WMS strategy search input base view
`WMS_STRATEGY_MEMBERS_V`	WMS strategy member view
`WMS_SUGGESTIONS_TEMP_V`	WMS SUGGESTIONS TEMP View
`WMS_SUGGESTIONS_TRACE_V`	WMS_SUGGESTIONS_TRACE View
`WMS_TASKS_V`
`WMS_TASK_FILTER_VL`	WMS Task Filter MLS View
`WMS_TASK_RELEASE_VL`
`WMS_TRX_DETAILS_TMP_V`	WMS rules execution input baes view
`WMS_TXN_REQUEST_LINES_TRACE_V`	WMS TXN Request Lines Trace View
`WMS_WAVEPLAN_TASKS_V`	WMS Wave Planning Task View
`WMS_WAVEPLAN_TASK_EXCEPTIONS_V`	WMS Wave Planning Task Exceptions View
`WMS_WP_EXCEPTIONS_GTMP_V`
`WMS_WP_LABOR_GTMP_V`
`WMS_WP_LINES_GTMP_V`
`WMS_WP_ORDERS_GTMP_V`
`WMS_WP_PLANNING_CRITERIA_VL`
`WMS_WP_REC_REQUESTS_GTMP_V`
`WMS_WP_REQUESTS_GTMP_V`
`WMS_WP_TASKS_GTMP_V`
`WMS_WP_WAVE_DETAILS_GTMP_V`
`WMS_WP_WAVE_EXCEPTIONS_VL`
`WMS_WP_WAVE_HEADERS_VL`
`WMS_WP_WWB_LINES_V`
`WMS_WP_WWB_ORDERS_V`
`WMS_XDOCK_SOURCE_ASSIGNMENTS_V`	Used by WMS Crossdock Criteria definition form
`WMS_ZONES_VL`
`WMS_ZONE_LOCATORS_ALL_V`	WMS Zones View to return all the subinventory, locator details of a zone.
`WMS_ZONE_LOCATORS_TEMP`	View built on temporary table wms_zone_locators_gtmp
`WMS_ZONE_LOCATORS_V`	Built on WMS_ZONE_LOCATORS
`WMS_ZONE_LPN_FOR_RULE`