VIEW: WMS.WMS_WP_WAVE_HEADERS_B#

Source

View Text - Preformatted

select WAVE_HEADER_ID WAVE_HEADER_ID, WAVE_SOURCE WAVE_SOURCE, WAVE_STATUS WAVE_STATUS, TYPE_ID TYPE_ID, BATCH_ID BATCH_ID, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, CUSTOMER_CLASS_ID CUSTOMER_CLASS_ID, PULL_REPLENISHMENT_FLAG PULL_REPLENISHMENT_FLAG, INITIATE_WAVE_PLANNING INITIATE_WAVE_PLANNING, RELEASE_IMMEDIATELY RELEASE_IMMEDIATELY, TABLE_NAME TABLE_NAME, ADVANCED_CRITERIA ADVANCED_CRITERIA, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ORGANIZATION_ID ORGANIZATION_ID, PICK_SEQ_RULE_ID PICK_SEQ_RULE_ID, PICK_GROUPING_RULE_ID PICK_GROUPING_RULE_ID, TRIP_ID TRIP_ID, TRIP_STOP_ID TRIP_STOP_ID, SHIP_METHOD_CODE SHIP_METHOD_CODE, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE, CARRIER_ID CARRIER_ID, DELIVERY_ID DELIVERY_ID, FROM_ORDER_HEADER_ID FROM_ORDER_HEADER_ID, ORDER_TYPE_ID ORDER_TYPE_ID, CUSTOMER_ID CUSTOMER_ID, TASK_ID TASK_ID, PROJECT_ID PROJECT_ID, CATEGORY_SET_ID CATEGORY_SET_ID, CATEGORY_ID CATEGORY_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, BACKORDERS_FLAG BACKORDERS_FLAG, INCLUDE_PLANNED_LINES INCLUDE_PLANNED_LINES, TASK_PLANNING_FLAG TASK_PLANNING_FLAG, APPEND_DELIVERIES APPEND_DELIVERIES, AUTO_CREATE_DELIVERY AUTO_CREATE_DELIVERY, AUTO_CREATE_DELIVERY_CRITERIA AUTO_CREATE_DELIVERY_CRITERIA, TASK_PRIORITY TASK_PRIORITY, DEFAULT_STAGE_SUBINVENTORY DEFAULT_STAGE_SUBINVENTORY, DEFAULT_STAGE_LOCATOR_ID DEFAULT_STAGE_LOCATOR_ID, DEFAULT_ALLOCATION_METHOD DEFAULT_ALLOCATION_METHOD, WAVE_FIRMED_FLAG WAVE_FIRMED_FLAG, WAVE_COMPLETION_TIME WAVE_COMPLETION_TIME, ORDER_NAME ORDER_NAME, CUSTOMER CUSTOMER, ORDER_TYPE ORDER_TYPE, CUSTOMER_CLASS CUSTOMER_CLASS, SHIP_METHOD SHIP_METHOD, CARRIER CARRIER, SHIP_PRIORITY SHIP_PRIORITY, DELIVERY DELIVERY, TRIP TRIP, TRIP_STOP TRIP_STOP, ITEM ITEM, ITEM_CATEGORY ITEM_CATEGORY, PROJECT_NAME PROJECT_NAME, TASK_NAME TASK_NAME, SCHEDULED_DAYS SCHEDULED_DAYS, SCHEDULED_HRS SCHEDULED_HRS, DOCK_APPOINTMENT_DAYS DOCK_APPOINTMENT_DAYS, DOCK_APPOINTMENT_HOURS DOCK_APPOINTMENT_HOURS, PICK_SLIP_GROUP PICK_SLIP_GROUP, RELEASE_SEQ_RULE RELEASE_SEQ_RULE, STAGING_SUBINVENTORY STAGING_SUBINVENTORY, STAGING_LOCATOR STAGING_LOCATOR, CROSS_DOCK_CRITERIA CROSS_DOCK_CRITERIA, PICK_SUBINVENTORY PICK_SUBINVENTORY, PLANNING_CRITERIA PLANNING_CRITERIA, PLANNING_CRITERIA_ID PLANNING_CRITERIA_ID, REQUEST_ID REQUEST_ID, 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, START_TIME START_TIME from "WMS"."WMS_WP_WAVE_HEADERS_B"

View Text - HTML Formatted

SELECT WAVE_HEADER_ID WAVE_HEADER_ID
, WAVE_SOURCE WAVE_SOURCE
, WAVE_STATUS WAVE_STATUS
, TYPE_ID TYPE_ID
, BATCH_ID BATCH_ID
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, CUSTOMER_CLASS_ID CUSTOMER_CLASS_ID
, PULL_REPLENISHMENT_FLAG PULL_REPLENISHMENT_FLAG
, INITIATE_WAVE_PLANNING INITIATE_WAVE_PLANNING
, RELEASE_IMMEDIATELY RELEASE_IMMEDIATELY
, TABLE_NAME TABLE_NAME
, ADVANCED_CRITERIA ADVANCED_CRITERIA
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORGANIZATION_ID ORGANIZATION_ID
, PICK_SEQ_RULE_ID PICK_SEQ_RULE_ID
, PICK_GROUPING_RULE_ID PICK_GROUPING_RULE_ID
, TRIP_ID TRIP_ID
, TRIP_STOP_ID TRIP_STOP_ID
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, CARRIER_ID CARRIER_ID
, DELIVERY_ID DELIVERY_ID
, FROM_ORDER_HEADER_ID FROM_ORDER_HEADER_ID
, ORDER_TYPE_ID ORDER_TYPE_ID
, CUSTOMER_ID CUSTOMER_ID
, TASK_ID TASK_ID
, PROJECT_ID PROJECT_ID
, CATEGORY_SET_ID CATEGORY_SET_ID
, CATEGORY_ID CATEGORY_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, BACKORDERS_FLAG BACKORDERS_FLAG
, INCLUDE_PLANNED_LINES INCLUDE_PLANNED_LINES
, TASK_PLANNING_FLAG TASK_PLANNING_FLAG
, APPEND_DELIVERIES APPEND_DELIVERIES
, AUTO_CREATE_DELIVERY AUTO_CREATE_DELIVERY
, AUTO_CREATE_DELIVERY_CRITERIA AUTO_CREATE_DELIVERY_CRITERIA
, TASK_PRIORITY TASK_PRIORITY
, DEFAULT_STAGE_SUBINVENTORY DEFAULT_STAGE_SUBINVENTORY
, DEFAULT_STAGE_LOCATOR_ID DEFAULT_STAGE_LOCATOR_ID
, DEFAULT_ALLOCATION_METHOD DEFAULT_ALLOCATION_METHOD
, WAVE_FIRMED_FLAG WAVE_FIRMED_FLAG
, WAVE_COMPLETION_TIME WAVE_COMPLETION_TIME
, ORDER_NAME ORDER_NAME
, CUSTOMER CUSTOMER
, ORDER_TYPE ORDER_TYPE
, CUSTOMER_CLASS CUSTOMER_CLASS
, SHIP_METHOD SHIP_METHOD
, CARRIER CARRIER
, SHIP_PRIORITY SHIP_PRIORITY
, DELIVERY DELIVERY
, TRIP TRIP
, TRIP_STOP TRIP_STOP
, ITEM ITEM
, ITEM_CATEGORY ITEM_CATEGORY
, PROJECT_NAME PROJECT_NAME
, TASK_NAME TASK_NAME
, SCHEDULED_DAYS SCHEDULED_DAYS
, SCHEDULED_HRS SCHEDULED_HRS
, DOCK_APPOINTMENT_DAYS DOCK_APPOINTMENT_DAYS
, DOCK_APPOINTMENT_HOURS DOCK_APPOINTMENT_HOURS
, PICK_SLIP_GROUP PICK_SLIP_GROUP
, RELEASE_SEQ_RULE RELEASE_SEQ_RULE
, STAGING_SUBINVENTORY STAGING_SUBINVENTORY
, STAGING_LOCATOR STAGING_LOCATOR
, CROSS_DOCK_CRITERIA CROSS_DOCK_CRITERIA
, PICK_SUBINVENTORY PICK_SUBINVENTORY
, PLANNING_CRITERIA PLANNING_CRITERIA
, PLANNING_CRITERIA_ID PLANNING_CRITERIA_ID
, REQUEST_ID REQUEST_ID
, 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
, START_TIME START_TIME
FROM "WMS"."WMS_WP_WAVE_HEADERS_B"