|
by oracleguru
Material Status COntrol is one of the finest features of Oracle Warehouse Management System (WMS) and Oracle Inventory (INV).
Each material will have a status based on subinventory/locator it is in (i.e. corresponding material status) or Lot or Serial status if the item is lot/serial controlled.
Material status control controls what transactions allowed/disallowed for that material.
by oracleguru
List of views in Oracle Warehouse Management System Module
| WMS_ACCESS_RULES_LOV_V |
| WMS_ACTIVE_EXCEPTIONS_V |
| WMS_ACTIVE_TASKS_V |
| WMS_BFLOW_LABEL_TYPE_DFV |
| WMS_BUS_EVENT_DEVICES_V |
| WMS_COMPLETED_EXCEPTIONS_V |
| WMS_COMPLETED_TASKS_V |
| WMS_COST_GROUPS_INPUT_V |
| WMS_CROSSDOCK_CRITERIA_VL |
| WMS_DEPARTMENT_SUBINVENTOR_DFV |
| WMS_DEPT_SUBINVENTORIES_V |
| WMS_DEPTS_V |
| WMS_DEVICE_REQUESTS_HIST_V |
| WMS_DEVICE_REQUESTS_WCSV |
| WMS_DEVICES_VL |
| WMS_DISPATCHABLE_TASKS_V |
| WMS_DOCK_APPOINTMENTS_V |
| WMS_DOCKS_V |
| WMS_ELS_GROUPED_TASKS_VL |
| WMS_ELS_INDIVIDUAL_TASKS_VL |
| WMS_EXCEPTIONS_V |
| WMS_ITEM_LOCATIONS_KFV |
| WMS_LABEL_FIELD_VARIABLES_DFV |
| WMS_LABEL_FIELD_VARIABLES_VL |
| WMS_LABEL_FIELDS_VL |
| WMS_LABEL_FORMATS_DFV |
| WMS_LABEL_FORMATS_V |
| WMS_LABEL_REQUESTS_HIST_V |
| WMS_LABEL_SET_FORMATS_V |
| WMS_LABELS_V |
| WMS_LICENSE_PLATE_NUMBERS_DFV |
| WMS_LICENSE_PLATE_NUMBERS_V |
| WMS_LOADED_QUANTITIES_V |
| WMS_LPN_CONTENTS_DETAIL_V |
| WMS_LPN_CONTENTS_LOT_V |
| WMS_LPN_CONTENTS_SERIAL_V |
| WMS_LPN_CONTENTS_V |
| WMS_OBJECTS_HIERARCHY_LOV_V |
| WMS_OBJECTS_OPERAND_LOV_V |
| WMS_OBJECTS_RULE_LOV_V |
| WMS_OBJECTS_STRATEGY_LOV_V |
| WMS_OBJECTS_STRATEGY_V |
| WMS_OBJECTS_VL |
| WMS_ONHAND_AND_LOADED_QTY_V |
| WMS_OP_PLAN_DETAILS_V |
| WMS_OP_PLANS_V |
| WMS_OP_PLANS_VL |
| WMS_ORG_HIERARCHY_OBJS_V |
| WMS_PACKING_KITTING_V |
| WMS_PACKING_LPN_CONT_V |
| WMS_PACKING_MATERIAL_V |
| WMS_PAGE_CONFIG_UI_V |
| WMS_PAGE_FIELDS_VL |
| WMS_PAGE_TEMPLATES_FIELDS_F_V |
| WMS_PAGE_TEMPLATES_VL |
| WMS_PARAMETERS_LOV_V |
| WMS_PARAMETERS_VL |
| WMS_PENDING_EXCEPTIONS_V |
| WMS_PENDING_TASKS_V |
| WMS_PERSON_RESOURCE_UTT_V |
| WMS_RESTRICTIONS_DFV |
| WMS_RESTRICTIONS_V |
| WMS_RULE_CONSISTENCIES_V |
| WMS_RULES_B_DFV |
| WMS_RULES_V |
| WMS_RULES_VL |
| WMS_SELECTION_CRITERIA_TXN_V |
| WMS_SHIP_TO_SITES_V |
| WMS_SORT_CRITERIA_DFV |
| WMS_SORT_CRITERIA_V |
| WMS_STAGINGLANES_ASSIGNMENTS_V |
| WMS_STRATEGIES_B_DFV |
| WMS_STRATEGIES_V |
| WMS_STRATEGIES_VL |
| WMS_STRATEGY_ASSIGNMENTS_DFV |
| WMS_STRATEGY_ASSIGNMENTS_V |
| WMS_STRATEGY_ASSIGNMENTS_V2 |
| WMS_STRATEGY_MAT_TXN_TMP_V |
| WMS_STRATEGY_MEMBERS_DFV |
| WMS_STRATEGY_MEMBERS_V |
| WMS_SUGGESTIONS_TEMP_V |
| WMS_SUGGESTIONS_TRACE_V |
| WMS_TASK_FILTER_VL |
| WMS_TASK_RELEASE_VL |
| WMS_TASKS_V |
| WMS_TRX_DETAILS_TMP_V |
| WMS_TXN_REQUEST_LINES_TRACE_V |
| WMS_WAVEPLAN_SUMMARY_V |
| WMS_WAVEPLAN_TASK_EXCEPTIONS_V |
| WMS_WAVEPLAN_TASKS_V |
| WMS_WAVEPLAN_TIME_PER_TASK_V |
| 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_WP_WWB_TASKS_V |
| WMS_XDOCK_SOURCE_ASSIGNMENTS_V |
| WMS_ZONE_LOCATORS_ALL_V |
| WMS_ZONE_LOCATORS_TEMP |
| WMS_ZONE_LOCATORS_V |
| WMS_ZONE_LPN_FOR_RULE |
| WMS_ZONES_VL |