You are browsing the archive for Technical Design.

Shipping Tables

Oracle Shipping Execution Tables:

  • WSH_ACTIVITY_GROUPS
  • WSH_CALENDAR_ASSIGNMENTS
  • WSH_CARRIERS
  • WSH_CARRIER_SERVICES
  • WSH_CARRIER_SHIP_METHODS
  • WSH_CARRIER_SITES
  • WSH_CARRIER_VEHICLE_TYPES
  • WSH_CC_ADAPTER_STATUS
  • WSH_CC_DENIED_PARTIES
  • WSH_CC_PARAMETER_SETUPS_B
  • WSH_CC_PARAMETER_SETUPS_TL
  • WSH_CC_REQUEST_SETUPS
  • WSH_CC_RESPONSE_HEADERS
  • WSH_CC_RESPONSE_LINES
  • WSH_CC_SERVICE_SETUPS
  • WSH_CC_TRANS_CONTROL
  • WSH_CC_TRANS_HEADERS
  • WSH_CC_TRANS_LINES
  • WSH_CC_USER_SETUPS
  • WSH_CONTAINER_ITEMS
  • WSH_DELIVERY_ASSIGNMENTS
  • WSH_DELIVERY_DETAILS
  • WSH_DELIVERY_LEGS
  • WSH_DELIVERY_LEG_ACTIVITIES
  • WSH_DELIVERY_LEG_DETAILS
  • WSH_DEL_ASSGN_INTERFACE
  • WSH_DEL_DETAILS_INTERFACE
  • WSH_DEL_LEGS_INTERFACE
  • WSH_DOCUMENT_INSTANCES
  • WSH_DOC_SEQUENCE_CATEGORIES
  • WSH_EXCEPTIONS
  • WSH_EXCEPTION_DEFINITIONS_B
  • WSH_EXCEPTION_DEFINITIONS_TL
  • WSH_FOLDER_CUSTOM_ACTIONS
  • WSH_FOLDER_EXTENSIONS
  • WSH_FREIGHT_COSTS
  • WSH_FREIGHT_COSTS_EFC
  • WSH_FREIGHT_COSTS_INTERFACE
  • WSH_FREIGHT_COST_TYPES
  • WSH_FTE_ACK_INTERFACE
  • WSH_FTE_CHARGES_INTERFACE
  • WSH_FTE_COMP_CLASSES
  • WSH_FTE_COMP_CONSTRAINTS
  • WSH_FTE_DLVY_DET_INTERFACE
  • WSH_FTE_DLVY_HDR_INTERFACE
  • WSH_FTE_EXCEPTION_INTERFACE
  • WSH_FTE_SCHEDULE_INTERFACE
  • WSH_FTE_TRANSACTION_EXCEPTIONS
  • WSH_FTE_TRANSACTION_HISTORY
  • WSH_GLOBAL_PARAMETERS
  • WSH_GRANTS
  • WSH_GTC_RESPONSE_RULES
  • WSH_INBOUND_TXN_HISTORY
  • WSH_INTERFACE_ERRORS
  • WSH_ITM_ADAPTER_STATUS
  • WSH_ITM_DENIED_PARTIES
  • WSH_ITM_ITEMS
  • WSH_ITM_PARAMETER_SETUPS_B
  • WSH_ITM_PARAMETER_SETUPS_TL
  • WSH_ITM_PARTIES
  • WSH_ITM_PARTY_CONTACTS
  • WSH_ITM_REQUEST_CONTROL
  • WSH_ITM_RESPONSE_HEADERS
  • WSH_ITM_RESPONSE_LINES
  • WSH_ITM_RESPONSE_RULES
  • WSH_ITM_SERVICE_PARAMETERS
  • WSH_ITM_SERVICE_PREFERENCES
  • WSH_ITM_USER_SETUPS
  • WSH_ITM_VENDORS
  • WSH_ITM_VENDOR_PARAMETERS
  • WSH_ITM_VENDOR_SERVICES
  • WSH_ITM_VENDOR_STYLESHEETS
  • WSH_LOCATIONS
  • WSH_LOCATION_DATA_EXT
  • WSH_LOCATION_OWNERS
  • WSH_MESSAGE_ATTACHMENT
  • WSH_NEW_DELIVERIES
  • WSH_NEW_DEL_INTERFACE
  • WSH_ORG_CARRIER_SERVICES
  • WSH_ORG_CARRIER_SITES
  • WSH_PICKING_BATCHES
  • WSH_PICKING_RULES
  • WSH_PICK_GROUPING_RULES
  • WSH_PICK_SEQUENCE_RULES
  • WSH_QUERY_ASSIGNMENTS
  • WSH_REGIONS
  • WSH_REGIONS_INTERFACE
  • WSH_REGIONS_TL
  • WSH_REGIONS_TL_INTERFACE
  • WSH_REGION_LOCATIONS
  • WSH_REPORT_PRINTERS
  • WSH_REPORT_SETS
  • WSH_REPORT_SET_LINES
  • WSH_ROLES
  • WSH_ROLE_PRIVILEGES
  • WSH_SAVED_QUERIES_B
  • WSH_SAVED_QUERIES_TL
  • WSH_SERIAL_NUMBERS
  • WSH_SHIPPING_PARAMETERS
  • WSH_SHIP_CONFIRM_RULES
  • WSH_TMP
  • WSH_TRANSACTIONS_HISTORY
  • WSH_TRIPS
  • WSH_TRIPS_INTERFACE
  • WSH_TRIP_STOPS
  • WSH_TRIP_STOPS_INTERFACE
  • WSH_UPGRADE_LOG
  • WSH_UPGRADE_PLD_TMP
  • WSH_UPGRADE_SITE_TMP
  • WSH_UPGRADE_TMP
  • WSH_WMS_SYNC_TMP
  • WSH_ZONE_REGIONS

Oracle Shipping Forms

Oracle Shipping Execution Forms:

FORM SHORT CODE ORACLE FORM NAME
WSHFCNIR Define Container Item Relationships
WSHFDDDS Define Document Sets Form
WSHFDPSD Assign Printers to Documents
WSHFDREL Define Release Rules Form
WSHFMDDS Define Document Sequences Form
WSHFPGRP Define Pick Slip Grouping Rules
WSHFPSEQ Define Release Sequence Rules
WSHFRREL Launch Pick Release Form
WSHFSPAR Define Shipping Parameters
WSHFSSWP Define Self Service Options Form
WSHFSTRX Shipping Transactions Form
WSHFXACF Assign Calendars Form
WSHFXCDF Define Shipping Exceptions Form
WSHFXCLG Shipping Exceptions Form
WSHFXCSM Freight Carriers
WSHFXFCT Freight Cost Types
WSHRGINT Regions Interface Form
WSHRGZON Regions and Zones Form
WSHCCUSR Users
WSHRQSET Request Preferences
WSHSVSET Service Preferences
WSHCCSET Parameters
WSHGTCRR Response Error Classification
WSHFTRST View Message History Form
WSHFSTAT View Detailed Shipping Status
WSHINTFR Shipment Message Corrections
WSHFILTM Shipment Transit Times
WSHFASCR Ship Confirm Rules Form
WSHFRUGD Shipping Grants and Role Definitions
WSHQSSUI Quick Ship
WSHFGPAR Define Global Parameters
WSHFRCST Freight Costs Form
WSHFCGRP Define Consolidation Grouping Rules
WSHFCSRS Process Consolidation SRS
WSHITUSR ITM Users
WSHITSET ITM Partners
WSHITSVP ITM Service Types
WSHITPAR ITM Parameters
WSHITERR ITM Response Error Classification

Views in Shipping and Execution Module

List of Views in Oracle Shipping and Execution Module

WSH_BACKORDER_LINES_V
WSH_BIS_BACKORDERED_SUM_V
WSH_BIS_FILL_BY_DAY_V
WSH_BIS_FILL_RATE_V
WSH_BIS_SHIPPED_BY_DAY_V
WSH_BIS_WAREHOUSE_DOCS_V
WSH_BOLS_DB_V
WSH_BOLS_RD_V
WSH_CAL_ASG_DETAIL_V
WSH_CAL_ASG_MASTER_V
WSH_CALENDAR_ASSIGNMENTS_DFV
WSH_CARRIER_ADDRESSES_V
WSH_CARRIER_CLASSIFICATIONS_V
WSH_CARRIER_CONTACT_INFO_V
WSH_CARRIER_CONTACTS_V
WSH_CARRIER_SERVICES_V
WSH_CARRIER_SHIP_METHODS_DFV
WSH_CARRIER_SHIP_METHODS_V
WSH_CARRIER_SITE_CONTACTS_V
WSH_CARRIER_SITE_DETAILS_V
WSH_CARRIER_SITECONTACT_INFO_V
WSH_CARRIER_SITES_MAIN_V
WSH_CARRIER_VEHICLE_TYPES_V
WSH_CARRIERS_V
WSH_CC_PARAMETER_SETUPS_VL
WSH_CC_REQUEST_SETUPS_V
WSH_CC_SERVICE_HEADER_SETUPS_V
WSH_CC_SERVICE_SETUPS_V
WSH_CC_USER_SETUPS_V
WSH_CHARGES_V
WSH_CMSTPW_ORDERS_V
WSH_CONSOL_BATCHES_V
WSH_CONTACT_PHONE
WSH_CONTAINER_CONTENTS_V
WSH_CONTAINER_ITEMS_DFV
WSH_CUSTOMER_LOCATIONS_V
WSH_CUSTOMER_PHONE
WSH_CUSTOMER_SITES_V
WSH_CUSTOMERS_ACTIVE_V
WSH_DEL_DTL_ASSGN_V
WSH_DELIVERABLE_STOPS_V
WSH_DELIVERABLE_TRIPS_V
WSH_DELIVERABLES_V
WSH_DELIVERIES_BOL_RDF_V
WSH_DELIVERIES_DFV
WSH_DELIVERIES_DPW_LOV_V
WSH_DELIVERIES1_DFV
WSH_DELIVERY_ASSIGNMENTS_V
WSH_DELIVERY_DETAILS_DFV
WSH_DELIVERY_DETAILS_OB_GRP_V
WSH_DELIVERY_DETAILS_OE_V
WSH_DELIVERY_LEGS_OB_GRP_V
WSH_DELIVERY_LINE_STATUS_V
WSH_DELIVERY_STOPS_V
WSH_DELIVERY_TRIPS_V
WSH_DEPARTURE_TEMPLATES_V
WSH_DEPARTURES_V
WSH_DLVB_DLVY_V
WSH_DLVB_SHIP_FROM_TO_V
WSH_DLVY_DELIVERABLES_V
WSH_DLVY_SHIP_FROM_TO_V
WSH_DOC_SEQUENCE_CATEGORIE_DFV
WSH_DOC_SEQUENCE_CATEGORIES_V
WSH_DOCUMENT_INSTANCES_DFV
WSH_DSNO_ALLOWANCE_CHARGES_V
WSH_DSNO_CONTAINERS_V
WSH_DSNO_DELIVERIES_V
WSH_DSNO_DELIVERY_ATTRIBS_V
WSH_DSNO_ITEM_DETAILS_V
WSH_DSNO_ITEMS_COMM_V
WSH_DSNO_ITEMS_SPECIFIC_V
WSH_DSNO_ITEMS_V
WSH_DSNO_ORDERS_COMM_V
WSH_DSNO_ORDERS_SPECIFIC_V
WSH_DSNO_ORDERS_V
WSH_DSNO_PACKED_QUANTITY_V
WSH_DSNO_UNIQUE_CONTAINERS_V
WSH_EXCEPTION_DEFINITIONS__DFV
WSH_EXCEPTION_DEFINITIONS_V
WSH_EXCEPTION_DEFINITIONS_VL
WSH_EXCEPTIONS_DFV
WSH_EXCEPTIONS_DLVY_V
WSH_EXCEPTIONS_V
WSH_FREIGHT_CARRIERS_ACTIVE_V
WSH_FREIGHT_COST_TYPES_DFV
WSH_FREIGHT_COST_TYPES_V
WSH_FREIGHT_COSTS_DFV
WSH_FREIGHT_COSTS_V
WSH_GRANTS_V
WSH_HR_LOCATIONS_V
WSH_INV_DELIVERY_DETAILS_V
WSH_ITM_CONTAINERS_V
WSH_ITM_PARAMETER_SETUPS_VL
WSH_ITM_PARTY_NAMES_V
WSH_ITM_PARTY_TYPES_V
WSH_ITM_REFERENCE_LINES_V
WSH_ITM_REFERENCE_NUMBERS_V
WSH_ITM_RESPONSE_RULES_V
WSH_ITM_RESPONSE_V
WSH_ITM_SERVICE_PREFERENCES_V
WSH_ITM_SHIPITEMS_V
WSH_ITM_SHIPMENT_V
WSH_ITM_SYNC_PARTIES_V
WSH_ITM_USER_SETUPS_V
WSH_LOAD_TENDER_CARGO_V
WSH_LOCATIONS_HR_V
WSH_LOCATIONS_HZ_V
WSH_LOCATIONS_REGIONS_V
WSH_LOCATIONS_V
WSH_LOOKUP_PRIVILEGES_V
WSH_LOOKUPS
WSH_NEW_DELIVERIES_DFV
WSH_NEW_DELIVERIES_OB_GRP_V
WSH_NEW_DELIVERIES_V
WSH_NEW_DELIVERIES2_DFV
WSH_OE_LINES_V1
WSH_OE_LINES_V2
WSH_ORDER_NUMBERS_V
WSH_ORDER_TYPES_REGULAR_V
WSH_ORG_CARRIER_SERVICES_DFV
WSH_ORG_CARRIER_SERVICES_V
WSH_ORG_CARRIER_SITES_V
WSH_PACK_SLIP_V
WSH_PACKED_CONTAINERS_DPW_V
WSH_PACKED_CONTAINERS_V
WSH_PACKING_SLIPS_DB_V
WSH_PARTY_SITES_V
WSH_PICK_GROUPING_RULES_DFV
WSH_PICK_LOT_TEMP_V
WSH_PICK_LOT_V
WSH_PICK_SEQUENCE_RULES_DFV
WSH_PICK_SERIAL_TEMP_V
WSH_PICK_SERIAL_V
WSH_PICK_SLIP_V
WSH_PICKING_BATCHES_DFV
WSH_PICKING_BATCHES_V
WSH_PICKING_DETAILS_INTERFACE
WSH_PICKING_RULES_DFV
WSH_PICKING_RULES_V
WSH_PICKING_UPGRADE_V
WSH_POD_CARGO_V
WSH_PRIMARY_CONTACT_PHONE_V
WSH_PRIMARY_CUSTOMER_PHONE_V
WSH_PURGE_SET_V
WSH_PURGE_SOURCE_NUMBERS_V
WSH_PURGE_SOURCE_TYPES_V
WSH_REG_LOC_MAPPING_V
WSH_REGION_LOCATIONS_VL
WSH_REGIONS_INTERFACE_V
WSH_REGIONS_V
WSH_REPORT_NAMES_V
WSH_REPORT_PRINTERS_DFV
WSH_REPORT_PRINTERS_V
WSH_REPORT_SET_LINES_DFV
WSH_REPORT_SETS_DFV
WSH_SAVED_QUERIES_VL
WSH_SHIP_CONFIRM_RULES_V
WSH_SHIP_FROM_LOCATIONS_V
WSH_SHIP_FROM_ORG_LOCATIONS_V
WSH_SHIP_FROM_ORGS_V
WSH_SHIP_TO_LOCATIONS_V
WSH_SHIPPING_DETAILS_V
WSH_SHIPPING_PARAMETERS_DFV
WSH_SOURCE_NUMBERS_V
WSH_SOURCE_TYPES_V
WSH_SRS_DSNO_TRIP_STOPS_V
WSH_SRS_PICK_SLIP_V
WSH_SRS_TRIP_STOPS_V
WSH_SS_CHARGE_V
WSH_SS_CONTAINERS_V
WSH_SS_PARTNER_V
WSH_SS_SHIPITEMS_V
WSH_SS_SHIPMENT_V
WSH_SS2_SHIPITEMS_V
WSH_SS2_SHIPMENT_V
WSH_STND_CONTAINERS_V
WSH_STND_DOC_NUMBERS_V
WSH_STND_INVDETAILS_V
WSH_STND_SHIPITEMS_V
WSH_STND_SHIPMENT_V
WSH_STOP_DELIVERABLES_V
WSH_STOP_DELIVERIES_V
WSH_SUPPLIER_SF_SITES_V
WSH_TRANSACTION_TYPES_VL
WSH_TRANSIT_TIMES_V
WSH_TRIP_DELIVERABLES_V
WSH_TRIP_DELIVERIES_V
WSH_TRIP_STOPS_DFV
WSH_TRIP_STOPS_OB_GRP_V
WSH_TRIP_STOPS_V
WSH_TRIPS_DFV
WSH_TRIPS_OB_GRP_V
WSH_TRIPS_V
WSH_XC_TRIP_STOPS_V
WSH_ZONE_REGIONS_V
WSHBV_CONTAINER_CONTENT
WSHBV_CONTAINER_CONTENTS
WSHBV_CONTAINER_ITEMS
WSHBV_CONTAINER_LOAD
WSHBV_CONTAINERS
WSHBV_DELIVERIES
WSHBV_DELIVERY
WSHBV_DELIVERY_ASSIGNMENTS
WSHBV_DELIVERY_DETAILS
WSHBV_DELIVERY_LEGS
WSHBV_DEPARTURE
WSHBV_DOCUMENT_BOL
WSHBV_DOCUMENT_PACKSLIP
WSHBV_FREIGHT_CHARGE
WSHBV_FREIGHT_CHARGE_TYPE
WSHBV_FREIGHT_COST_TYPES
WSHBV_FREIGHT_COSTS
WSHBV_LINE_PICK_SEQUENCE_RULE
WSHBV_LOCATIONS
WSHBV_PACKED_CONTAINER
WSHBV_PICK_HEADER
WSHBV_PICK_LINE
WSHBV_PICK_LINE_DETAIL
WSHBV_PICK_LINE_GROUPING_RULE
WSHBV_PICK_RELEASE_RULE
WSHBV_PICK_SEQUENCE_RULES
WSHBV_PICK_SLIP_GROUPING_RULES
WSHBV_PICKING_BATCH
WSHBV_PICKING_BATCHES
WSHBV_PICKING_RULES
WSHBV_TRIP_STOPS
WSHBV_TRIPS
WSHFV_CONTAINER_CONTENT
WSHFV_CONTAINER_CONTENTS
WSHFV_CONTAINER_ITEMS
WSHFV_CONTAINER_LOAD
WSHFV_CONTAINERS
WSHFV_DELIVERIES
WSHFV_DELIVERY_ASSIGNMENTS
WSHFV_DELIVERY_DETAILS
WSHFV_DELIVERY_LEGS
WSHFV_DEPARTURE
WSHFV_DOCUMENT_BOL
WSHFV_DOCUMENT_PACKSLIP
WSHFV_FREIGHT_CHARGE
WSHFV_FREIGHT_CHARGE_TYPE
WSHFV_FREIGHT_COST_TYPES
WSHFV_FREIGHT_COSTS
WSHFV_LINE_PICK_SEQUENCE_RULE
WSHFV_LOCATIONS
WSHFV_PACKED_CONTAINER
WSHFV_PICK_LINE_GROUPING_RULE
WSHFV_PICK_SEQUENCE_RULES
WSHFV_PICK_SLIP_GROUPING_RULES
WSHFV_PICKING_BATCHES
WSHFV_PICKING_RULES
WSHFV_TRIP_STOPS
WSHFV_TRIPS