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_CONSOL_BATCHES#

Source

View Text - Preformatted


select BATCH_ID BATCH_ID, ORGANIZATION_ID ORGANIZATION_ID, CONSOL_GROUPING_RULE_ID CONSOL_GROUPING_RULE_ID, CONSOL_SHIP_TO_LOCATION_ID CONSOL_SHIP_TO_LOCATION_ID, SHIP_TO_OVERIDE_FLAG SHIP_TO_OVERIDE_FLAG, DELIVERY_NAME_FROM DELIVERY_NAME_FROM, DELIVERY_NAME_TO DELIVERY_NAME_TO, PICKUP_START_DAYS PICKUP_START_DAYS, PICKUP_END_DAYS PICKUP_END_DAYS, DROPOFF_START_DAYS DROPOFF_START_DAYS, DROPOFF_END_DAYS DROPOFF_END_DAYS, PR_BATCH_ID PR_BATCH_ID, CUSTOMER_ID CUSTOMER_ID, FOB_CODE FOB_CODE, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, CARRIER_ID CARRIER_ID, MODE_OF_TRANSPORT MODE_OF_TRANSPORT, SERVICE_LEVEL SERVICE_LEVEL, LOADING_SEQUENCE LOADING_SEQUENCE, INTMED_SHIP_TO_LOCATION_ID INTMED_SHIP_TO_LOCATION_ID, ULTI_SHIP_TO_LOCATION_ID ULTI_SHIP_TO_LOCATION_ID, ULTI_SHIP_TO_REGION ULTI_SHIP_TO_REGION, ULTI_SHIP_TO_ZIP_FROM ULTI_SHIP_TO_ZIP_FROM, ULTI_SHIP_TO_ZIP_TO ULTI_SHIP_TO_ZIP_TO, ULTI_SHIP_TO_ZONE ULTI_SHIP_TO_ZONE, INCL_STAGED_DEL_FLAG INCL_STAGED_DEL_FLAG, INCL_DEL_ASG_TRIPS_FLAG INCL_DEL_ASG_TRIPS_FLAG, CR_TRIP_TO_ULTM_SHIP_TO CR_TRIP_TO_ULTM_SHIP_TO, ROUTE_TRIPS_FLAG ROUTE_TRIPS_FLAG, RATE_TRIPS_FLAG RATE_TRIPS_FLAG, TRIP_NAME_PREFIX TRIP_NAME_PREFIX, MAX_TRIP_WEIGHT MAX_TRIP_WEIGHT, MAX_TRIP_WEIGHT_UOM MAX_TRIP_WEIGHT_UOM, 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 from "WSH"."WSH_CONSOL_BATCHES"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, ORGANIZATION_ID ORGANIZATION_ID
, CONSOL_GROUPING_RULE_ID CONSOL_GROUPING_RULE_ID
, CONSOL_SHIP_TO_LOCATION_ID CONSOL_SHIP_TO_LOCATION_ID
, SHIP_TO_OVERIDE_FLAG SHIP_TO_OVERIDE_FLAG
, DELIVERY_NAME_FROM DELIVERY_NAME_FROM
, DELIVERY_NAME_TO DELIVERY_NAME_TO
, PICKUP_START_DAYS PICKUP_START_DAYS
, PICKUP_END_DAYS PICKUP_END_DAYS
, DROPOFF_START_DAYS DROPOFF_START_DAYS
, DROPOFF_END_DAYS DROPOFF_END_DAYS
, PR_BATCH_ID PR_BATCH_ID
, CUSTOMER_ID CUSTOMER_ID
, FOB_CODE FOB_CODE
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, CARRIER_ID CARRIER_ID
, MODE_OF_TRANSPORT MODE_OF_TRANSPORT
, SERVICE_LEVEL SERVICE_LEVEL
, LOADING_SEQUENCE LOADING_SEQUENCE
, INTMED_SHIP_TO_LOCATION_ID INTMED_SHIP_TO_LOCATION_ID
, ULTI_SHIP_TO_LOCATION_ID ULTI_SHIP_TO_LOCATION_ID
, ULTI_SHIP_TO_REGION ULTI_SHIP_TO_REGION
, ULTI_SHIP_TO_ZIP_FROM ULTI_SHIP_TO_ZIP_FROM
, ULTI_SHIP_TO_ZIP_TO ULTI_SHIP_TO_ZIP_TO
, ULTI_SHIP_TO_ZONE ULTI_SHIP_TO_ZONE
, INCL_STAGED_DEL_FLAG INCL_STAGED_DEL_FLAG
, INCL_DEL_ASG_TRIPS_FLAG INCL_DEL_ASG_TRIPS_FLAG
, CR_TRIP_TO_ULTM_SHIP_TO CR_TRIP_TO_ULTM_SHIP_TO
, ROUTE_TRIPS_FLAG ROUTE_TRIPS_FLAG
, RATE_TRIPS_FLAG RATE_TRIPS_FLAG
, TRIP_NAME_PREFIX TRIP_NAME_PREFIX
, MAX_TRIP_WEIGHT MAX_TRIP_WEIGHT
, MAX_TRIP_WEIGHT_UOM MAX_TRIP_WEIGHT_UOM
, 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
FROM "WSH"."WSH_CONSOL_BATCHES"