VIEW: APPS.WMS_WP_WAVE_HEADERS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')