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.

[Home] [Help]

VIEW: WMS.WMS_WP_PLANNING_CRITERIA_B#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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