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.

[Home] [Help]

View: WMS_WP_WAVE_HEADERS_VL

Product:	WMS - Warehouse Management
Description:
Implementation/DBA Data:	APPS.WMS_WP_WAVE_HEADERS_VL

View Text

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

Columns

Name
ROW_ID
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
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
WAVE_NAME
WAVE_DESCRIPTION
START_TIME