DBA Data[Home] [Help] [Dependency Information]

TABLE: WMS.WMS_WP_WAVE_HEADERS_B

Object Details
Object Name: WMS_WP_WAVE_HEADERS_B
Object Type: TABLE
Owner: WMS
Subobject Name:
Status: VALID


Stores waves and wave template information for Wave Planning


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WMS_WP_WAVE_HEADERS_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWAVE_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
WAVE_HEADER_ID NUMBER
Yes wave header id
WAVE_SOURCE VARCHAR2 (5)
wave source
WAVE_STATUS VARCHAR2 (30)
wave status
TYPE_ID VARCHAR2 (1)
wave type
BATCH_ID NUMBER

batch id
SHIP_TO_LOCATION_ID NUMBER

ship to location id
CUSTOMER_CLASS_ID VARCHAR2 (100)
customer class id
PULL_REPLENISHMENT_FLAG VARCHAR2 (1)
pull replenishment flag
INITIATE_WAVE_PLANNING VARCHAR2 (1)
initiate wave planning
RELEASE_IMMEDIATELY VARCHAR2 (1)
release immediately
TABLE_NAME VARCHAR2 (100)
table name
ADVANCED_CRITERIA VARCHAR2 (4000)
advanced criteria
CREATED_BY NUMBER

created by
CREATION_DATE DATE

creation date
LAST_UPDATED_BY NUMBER

last updated by
LAST_UPDATE_DATE DATE

last update date
LAST_UPDATE_LOGIN NUMBER

last update login
ORGANIZATION_ID NUMBER

organization id
PICK_SEQ_RULE_ID NUMBER

pick seq rule id
PICK_GROUPING_RULE_ID NUMBER

pick grouping rule id
TRIP_ID NUMBER

trip id
TRIP_STOP_ID NUMBER

trip stop id
SHIP_METHOD_CODE VARCHAR2 (30)
ship method code
SHIPMENT_PRIORITY_CODE VARCHAR2 (30)
shipment priority code
CARRIER_ID NUMBER

carrier id
DELIVERY_ID NUMBER

delivery id
FROM_ORDER_HEADER_ID NUMBER

from order header id
ORDER_TYPE_ID NUMBER

order type id
CUSTOMER_ID NUMBER

customer id
TASK_ID NUMBER

task id
PROJECT_ID NUMBER

project id
CATEGORY_SET_ID NUMBER

category set id
CATEGORY_ID NUMBER

category id
INVENTORY_ITEM_ID NUMBER

inventory item id
BACKORDERS_FLAG VARCHAR2 (1)
backorders flag
INCLUDE_PLANNED_LINES VARCHAR2 (1)
include planned lines flag
TASK_PLANNING_FLAG VARCHAR2 (1)
task planning flag
APPEND_DELIVERIES VARCHAR2 (1)
append deliveries
AUTO_CREATE_DELIVERY VARCHAR2 (1)
autocreate delivery
AUTO_CREATE_DELIVERY_CRITERIA VARCHAR2 (1)
autocreate delivery criteria
TASK_PRIORITY NUMBER

task priority
DEFAULT_STAGE_SUBINVENTORY VARCHAR2 (30)
default stage subinventory
DEFAULT_STAGE_LOCATOR_ID NUMBER

default staging locator
DEFAULT_ALLOCATION_METHOD VARCHAR2 (5)
default allocation method
WAVE_FIRMED_FLAG VARCHAR2 (1)
wave firmed flag
WAVE_COMPLETION_TIME DATE

wave completion time
ORDER_NAME VARCHAR2 (100)
order name
CUSTOMER VARCHAR2 (200)
customer
ORDER_TYPE VARCHAR2 (100)
order type
CUSTOMER_CLASS VARCHAR2 (200)
customer class
SHIP_METHOD VARCHAR2 (100)
ship method
CARRIER VARCHAR2 (100)
carrier
SHIP_PRIORITY VARCHAR2 (100)
ship priority
DELIVERY VARCHAR2 (100)
delivery
TRIP VARCHAR2 (100)
trip
TRIP_STOP VARCHAR2 (100)
trip stop
ITEM VARCHAR2 (200)
item
ITEM_CATEGORY VARCHAR2 (300)
item category
PROJECT_NAME VARCHAR2 (150)
project name
TASK_NAME VARCHAR2 (150)
task name
SCHEDULED_DAYS NUMBER

scheduled days
SCHEDULED_HRS NUMBER

scheduled hours
DOCK_APPOINTMENT_DAYS NUMBER

dock appointment days
DOCK_APPOINTMENT_HOURS NUMBER

dock appointment hours
PICK_SLIP_GROUP VARCHAR2 (150)
pick slip group
RELEASE_SEQ_RULE VARCHAR2 (150)
release sequence rule
STAGING_SUBINVENTORY VARCHAR2 (30)
staging subinventory
STAGING_LOCATOR VARCHAR2 (150)
staging locator
CROSS_DOCK_CRITERIA VARCHAR2 (100)
crossdock criteria
PICK_SUBINVENTORY VARCHAR2 (30)
pick subinventory
PLANNING_CRITERIA VARCHAR2 (100)
planning criteria
PLANNING_CRITERIA_ID NUMBER

planning criteria id
REQUEST_ID NUMBER

request id
ATTRIBUTE_CATEGORY VARCHAR2 (150)
attribute category
ATTRIBUTE1 VARCHAR2 (150)
attribute1
ATTRIBUTE2 VARCHAR2 (150)
attribute2
ATTRIBUTE3 VARCHAR2 (150)
attribute3
ATTRIBUTE4 VARCHAR2 (150)
attribute4
ATTRIBUTE5 VARCHAR2 (150)
attribute5
ATTRIBUTE6 VARCHAR2 (150)
attribute6
ATTRIBUTE7 VARCHAR2 (150)
attribute7
ATTRIBUTE8 VARCHAR2 (150)
attribute8
ATTRIBUTE9 VARCHAR2 (150)
attribute9
ATTRIBUTE10 VARCHAR2 (150)
attribute10
ATTRIBUTE11 VARCHAR2 (150)
attribute11
ATTRIBUTE12 VARCHAR2 (150)
attribute12
ATTRIBUTE13 VARCHAR2 (150)
attribute13
ATTRIBUTE14 VARCHAR2 (150)
attribute14
ATTRIBUTE15 VARCHAR2 (150)
attribute15
START_TIME DATE

start time
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT WAVE_HEADER_ID
,      WAVE_SOURCE
,      WAVE_STATUS
,      TYPE_ID
,      BATCH_ID
,      SHIP_TO_LOCATION_ID
,      CUSTOMER_CLASS_ID
,      PULL_REPLENISHMENT_FLAG
,      INITIATE_WAVE_PLANNING
,      RELEASE_IMMEDIATELY
,      TABLE_NAME
,      ADVANCED_CRITERIA
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      PICK_SEQ_RULE_ID
,      PICK_GROUPING_RULE_ID
,      TRIP_ID
,      TRIP_STOP_ID
,      SHIP_METHOD_CODE
,      SHIPMENT_PRIORITY_CODE
,      CARRIER_ID
,      DELIVERY_ID
,      FROM_ORDER_HEADER_ID
,      ORDER_TYPE_ID
,      CUSTOMER_ID
,      TASK_ID
,      PROJECT_ID
,      CATEGORY_SET_ID
,      CATEGORY_ID
,      INVENTORY_ITEM_ID
,      BACKORDERS_FLAG
,      INCLUDE_PLANNED_LINES
,      TASK_PLANNING_FLAG
,      APPEND_DELIVERIES
,      AUTO_CREATE_DELIVERY
,      AUTO_CREATE_DELIVERY_CRITERIA
,      TASK_PRIORITY
,      DEFAULT_STAGE_SUBINVENTORY
,      DEFAULT_STAGE_LOCATOR_ID
,      DEFAULT_ALLOCATION_METHOD
,      WAVE_FIRMED_FLAG
,      WAVE_COMPLETION_TIME
,      ORDER_NAME
,      CUSTOMER
,      ORDER_TYPE
,      CUSTOMER_CLASS
,      SHIP_METHOD
,      CARRIER
,      SHIP_PRIORITY
,      DELIVERY
,      TRIP
,      TRIP_STOP
,      ITEM
,      ITEM_CATEGORY
,      PROJECT_NAME
,      TASK_NAME
,      SCHEDULED_DAYS
,      SCHEDULED_HRS
,      DOCK_APPOINTMENT_DAYS
,      DOCK_APPOINTMENT_HOURS
,      PICK_SLIP_GROUP
,      RELEASE_SEQ_RULE
,      STAGING_SUBINVENTORY
,      STAGING_LOCATOR
,      CROSS_DOCK_CRITERIA
,      PICK_SUBINVENTORY
,      PLANNING_CRITERIA
,      PLANNING_CRITERIA_ID
,      REQUEST_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      START_TIME
FROM WMS.WMS_WP_WAVE_HEADERS_B;

Dependencies

[top of page]

WMS.WMS_WP_WAVE_HEADERS_B does not reference any database object

WMS.WMS_WP_WAVE_HEADERS_B is referenced by following:

SchemaWMS
ViewWMS_WP_WAVE_HEADERS_B#