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.

VIEW: WSH.WSH_SHIPPING_PARAMETERS#

Source

View Text - Preformatted


select GOODS_DISPATCHED_ACCOUNT GOODS_DISPATCHED_ACCOUNT, LOCATION_ID LOCATION_ID, ORGANIZATION_ID ORGANIZATION_ID, WEIGHT_UOM_CLASS WEIGHT_UOM_CLASS, VOLUME_UOM_CLASS VOLUME_UOM_CLASS, WEIGHT_VOLUME_FLAG WEIGHT_VOLUME_FLAG, INV_CONTROLS_CONTAINER_FLAG INV_CONTROLS_CONTAINER_FLAG, PERCENT_FILL_BASIS_FLAG PERCENT_FILL_BASIS_FLAG, TRIP_REPORT_SET_ID TRIP_REPORT_SET_ID, DELIVERY_REPORT_SET_ID DELIVERY_REPORT_SET_ID, PACK_SLIP_REQUIRED_FLAG PACK_SLIP_REQUIRED_FLAG, PICK_SEQUENCE_RULE_ID PICK_SEQUENCE_RULE_ID, PICK_GROUPING_RULE_ID PICK_GROUPING_RULE_ID, PRINT_PICK_SLIP_MODE PRINT_PICK_SLIP_MODE, PICK_RELEASE_REPORT_SET_ID PICK_RELEASE_REPORT_SET_ID, AUTOCREATE_DEL_ORDERS_FLAG AUTOCREATE_DEL_ORDERS_FLAG, DEFAULT_STAGE_SUBINVENTORY DEFAULT_STAGE_SUBINVENTORY, DEFAULT_STAGE_LOCATOR_ID DEFAULT_STAGE_LOCATOR_ID, AUTODETAIL_PR_FLAG AUTODETAIL_PR_FLAG, ENFORCE_PACKING_FLAG ENFORCE_PACKING_FLAG, GROUP_BY_CUSTOMER_FLAG GROUP_BY_CUSTOMER_FLAG, GROUP_BY_FOB_FLAG GROUP_BY_FOB_FLAG, GROUP_BY_FREIGHT_TERMS_FLAG GROUP_BY_FREIGHT_TERMS_FLAG, GROUP_BY_INTMED_SHIP_TO_FLAG GROUP_BY_INTMED_SHIP_TO_FLAG, GROUP_BY_SHIP_METHOD_FLAG GROUP_BY_SHIP_METHOD_FLAG, GROUP_BY_CARRIER_FLAG GROUP_BY_CARRIER_FLAG, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, PICK_SLIP_LINES PICK_SLIP_LINES, AUTOCREATE_DELIVERIES_FLAG AUTOCREATE_DELIVERIES_FLAG, FREIGHT_CLASS_CAT_SET_ID FREIGHT_CLASS_CAT_SET_ID, COMMODITY_CODE_CAT_SET_ID COMMODITY_CODE_CAT_SET_ID, ENFORCE_SHIP_SET_AND_SMC ENFORCE_SHIP_SET_AND_SMC, AUTO_SEND_DOC_FLAG AUTO_SEND_DOC_FLAG, ITM_ADDITIONAL_COUNTRY_CODE ITM_ADDITIONAL_COUNTRY_CODE, AUTO_SELECT_CARRIER AUTO_SELECT_CARRIER, SHIP_CONFIRM_RULE_ID SHIP_CONFIRM_RULE_ID, AUTOPACK_LEVEL AUTOPACK_LEVEL, TASK_PLANNING_FLAG TASK_PLANNING_FLAG, APPENDING_LIMIT APPENDING_LIMIT, IGNORE_INBOUND_TRIP IGNORE_INBOUND_TRIP, EXPORT_SCREENING_FLAG EXPORT_SCREENING_FLAG, AUTOCREATE_DEL_ORDERS_PR_FLAG AUTOCREATE_DEL_ORDERS_PR_FLAG, FPA_POSITIVE_TOL_AMT FPA_POSITIVE_TOL_AMT, FPA_NEGATIVE_TOL_AMT FPA_NEGATIVE_TOL_AMT, FPA_POSITIVE_TOL_PERCENTAGE FPA_POSITIVE_TOL_PERCENTAGE, FPA_NEGATIVE_TOL_PERCENTAGE FPA_NEGATIVE_TOL_PERCENTAGE, FPA_DEFAULT_FREIGHT_ACCOUNT FPA_DEFAULT_FREIGHT_ACCOUNT, AUTO_APPLY_ROUTING_RULES AUTO_APPLY_ROUTING_RULES, AUTO_CALC_FGT_RATE_CR_DEL AUTO_CALC_FGT_RATE_CR_DEL, AUTO_CALC_FGT_RATE_APPEND_DEL AUTO_CALC_FGT_RATE_APPEND_DEL, AUTO_CALC_FGT_RATE_SC_DEL AUTO_CALC_FGT_RATE_SC_DEL, CHECK_ON_HAND CHECK_ON_HAND, RAISE_BUSINESS_EVENTS RAISE_BUSINESS_EVENTS, ENABLE_TRACKING_WFS ENABLE_TRACKING_WFS, ENABLE_SC_WF ENABLE_SC_WF, MAX_NET_WEIGHT MAX_NET_WEIGHT, MAX_GROSS_WEIGHT MAX_GROSS_WEIGHT, OTM_ENABLED OTM_ENABLED, DYNAMIC_REPLENISHMENT_FLAG DYNAMIC_REPLENISHMENT_FLAG, DOCK_APPT_SCHEDULING_FLAG DOCK_APPT_SCHEDULING_FLAG, RETAIN_NONSTAGED_DET_FLAG RETAIN_NONSTAGED_DET_FLAG, WEIGHT_UOM_CODE WEIGHT_UOM_CODE, VOLUME_UOM_CODE VOLUME_UOM_CODE from "WSH"."WSH_SHIPPING_PARAMETERS"

View Text - HTML Formatted

SELECT GOODS_DISPATCHED_ACCOUNT GOODS_DISPATCHED_ACCOUNT
, LOCATION_ID LOCATION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, WEIGHT_UOM_CLASS WEIGHT_UOM_CLASS
, VOLUME_UOM_CLASS VOLUME_UOM_CLASS
, WEIGHT_VOLUME_FLAG WEIGHT_VOLUME_FLAG
, INV_CONTROLS_CONTAINER_FLAG INV_CONTROLS_CONTAINER_FLAG
, PERCENT_FILL_BASIS_FLAG PERCENT_FILL_BASIS_FLAG
, TRIP_REPORT_SET_ID TRIP_REPORT_SET_ID
, DELIVERY_REPORT_SET_ID DELIVERY_REPORT_SET_ID
, PACK_SLIP_REQUIRED_FLAG PACK_SLIP_REQUIRED_FLAG
, PICK_SEQUENCE_RULE_ID PICK_SEQUENCE_RULE_ID
, PICK_GROUPING_RULE_ID PICK_GROUPING_RULE_ID
, PRINT_PICK_SLIP_MODE PRINT_PICK_SLIP_MODE
, PICK_RELEASE_REPORT_SET_ID PICK_RELEASE_REPORT_SET_ID
, AUTOCREATE_DEL_ORDERS_FLAG AUTOCREATE_DEL_ORDERS_FLAG
, DEFAULT_STAGE_SUBINVENTORY DEFAULT_STAGE_SUBINVENTORY
, DEFAULT_STAGE_LOCATOR_ID DEFAULT_STAGE_LOCATOR_ID
, AUTODETAIL_PR_FLAG AUTODETAIL_PR_FLAG
, ENFORCE_PACKING_FLAG ENFORCE_PACKING_FLAG
, GROUP_BY_CUSTOMER_FLAG GROUP_BY_CUSTOMER_FLAG
, GROUP_BY_FOB_FLAG GROUP_BY_FOB_FLAG
, GROUP_BY_FREIGHT_TERMS_FLAG GROUP_BY_FREIGHT_TERMS_FLAG
, GROUP_BY_INTMED_SHIP_TO_FLAG GROUP_BY_INTMED_SHIP_TO_FLAG
, GROUP_BY_SHIP_METHOD_FLAG GROUP_BY_SHIP_METHOD_FLAG
, GROUP_BY_CARRIER_FLAG GROUP_BY_CARRIER_FLAG
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, PICK_SLIP_LINES PICK_SLIP_LINES
, AUTOCREATE_DELIVERIES_FLAG AUTOCREATE_DELIVERIES_FLAG
, FREIGHT_CLASS_CAT_SET_ID FREIGHT_CLASS_CAT_SET_ID
, COMMODITY_CODE_CAT_SET_ID COMMODITY_CODE_CAT_SET_ID
, ENFORCE_SHIP_SET_AND_SMC ENFORCE_SHIP_SET_AND_SMC
, AUTO_SEND_DOC_FLAG AUTO_SEND_DOC_FLAG
, ITM_ADDITIONAL_COUNTRY_CODE ITM_ADDITIONAL_COUNTRY_CODE
, AUTO_SELECT_CARRIER AUTO_SELECT_CARRIER
, SHIP_CONFIRM_RULE_ID SHIP_CONFIRM_RULE_ID
, AUTOPACK_LEVEL AUTOPACK_LEVEL
, TASK_PLANNING_FLAG TASK_PLANNING_FLAG
, APPENDING_LIMIT APPENDING_LIMIT
, IGNORE_INBOUND_TRIP IGNORE_INBOUND_TRIP
, EXPORT_SCREENING_FLAG EXPORT_SCREENING_FLAG
, AUTOCREATE_DEL_ORDERS_PR_FLAG AUTOCREATE_DEL_ORDERS_PR_FLAG
, FPA_POSITIVE_TOL_AMT FPA_POSITIVE_TOL_AMT
, FPA_NEGATIVE_TOL_AMT FPA_NEGATIVE_TOL_AMT
, FPA_POSITIVE_TOL_PERCENTAGE FPA_POSITIVE_TOL_PERCENTAGE
, FPA_NEGATIVE_TOL_PERCENTAGE FPA_NEGATIVE_TOL_PERCENTAGE
, FPA_DEFAULT_FREIGHT_ACCOUNT FPA_DEFAULT_FREIGHT_ACCOUNT
, AUTO_APPLY_ROUTING_RULES AUTO_APPLY_ROUTING_RULES
, AUTO_CALC_FGT_RATE_CR_DEL AUTO_CALC_FGT_RATE_CR_DEL
, AUTO_CALC_FGT_RATE_APPEND_DEL AUTO_CALC_FGT_RATE_APPEND_DEL
, AUTO_CALC_FGT_RATE_SC_DEL AUTO_CALC_FGT_RATE_SC_DEL
, CHECK_ON_HAND CHECK_ON_HAND
, RAISE_BUSINESS_EVENTS RAISE_BUSINESS_EVENTS
, ENABLE_TRACKING_WFS ENABLE_TRACKING_WFS
, ENABLE_SC_WF ENABLE_SC_WF
, MAX_NET_WEIGHT MAX_NET_WEIGHT
, MAX_GROSS_WEIGHT MAX_GROSS_WEIGHT
, OTM_ENABLED OTM_ENABLED
, DYNAMIC_REPLENISHMENT_FLAG DYNAMIC_REPLENISHMENT_FLAG
, DOCK_APPT_SCHEDULING_FLAG DOCK_APPT_SCHEDULING_FLAG
, RETAIN_NONSTAGED_DET_FLAG RETAIN_NONSTAGED_DET_FLAG
, WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, VOLUME_UOM_CODE VOLUME_UOM_CODE
FROM "WSH"."WSH_SHIPPING_PARAMETERS"