[Home] [Help] [Dependency Information]
Object Name: | WSH_PICKING_BATCHES# |
---|---|
Object Type: | VIEW |
Owner: | WSH |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | Yes | ||
NAME | VARCHAR2 | (30) | Yes | |
BACKORDERS_ONLY_FLAG | VARCHAR2 | (1) | ||
DOCUMENT_SET_ID | NUMBER | |||
EXISTING_RSVS_ONLY_FLAG | VARCHAR2 | (1) | ||
SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | ||
SHIP_METHOD_CODE | VARCHAR2 | (30) | ||
CARRIER_ID | NUMBER | |||
CUSTOMER_ID | NUMBER | |||
SHIP_TO_LOCATION_ID | NUMBER | |||
ORDER_HEADER_ID | NUMBER | |||
ORDER_LINE_ID | NUMBER | |||
SHIP_SET_NUMBER | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
ORDER_TYPE_ID | NUMBER | |||
FROM_REQUESTED_DATE | DATE | |||
TO_REQUESTED_DATE | DATE | |||
FROM_SCHEDULED_SHIP_DATE | DATE | |||
TO_SCHEDULED_SHIP_DATE | DATE | |||
SUBINVENTORY | VARCHAR2 | (10) | ||
SHIP_FROM_LOCATION_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
DEFAULT_STAGE_SUBINVENTORY | VARCHAR2 | (10) | ||
DEFAULT_STAGE_LOCATOR_ID | NUMBER | |||
PICK_FROM_SUBINVENTORY | VARCHAR2 | (10) | ||
PICK_FROM_LOCATOR_ID | NUMBER | |||
AUTODETAIL_PR_FLAG | VARCHAR2 | (1) | ||
AUTO_PICK_CONFIRM_FLAG | VARCHAR2 | (1) | ||
TRIP_ID | NUMBER | |||
TRIP_STOP_ID | NUMBER | |||
DELIVERY_ID | NUMBER | |||
DELIVERY_DETAIL_ID | NUMBER | |||
PICK_GROUPING_RULE_ID | NUMBER | |||
PICK_SEQUENCE_RULE_ID | NUMBER | |||
PARTIAL_ALLOWED_FLAG | VARCHAR2 | (1) | ||
INCLUDE_PLANNED_LINES | VARCHAR2 | (1) | ||
AUTOCREATE_DELIVERY_FLAG | VARCHAR2 | (1) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
REQUEST_ID | NUMBER | |||
PROJECT_ID | NUMBER | |||
TASK_ID | NUMBER | |||
AUTO_SEND_DOC_FLAG | VARCHAR2 | (1) | ||
NON_PICKING_FLAG | VARCHAR2 | (1) | ||
SHIP_CONFIRM_RULE_ID | NUMBER | |||
AUTOPACK_FLAG | VARCHAR2 | (1) | ||
AUTOPACK_LEVEL | NUMBER | |||
DELIVERY_NAME_LO | VARCHAR2 | (30) | ||
DELIVERY_NAME_HI | VARCHAR2 | (30) | ||
BOL_NUMBER_LO | VARCHAR2 | (50) | ||
BOL_NUMBER_HI | VARCHAR2 | (50) | ||
INTMED_SHIP_TO_LOC_ID | NUMBER | |||
POOLED_SHIP_TO_LOC_ID | NUMBER | |||
FOB_CODE | VARCHAR2 | (30) | ||
FREIGHT_TERMS_CODE | VARCHAR2 | (30) | ||
PICKUP_DATE_LO | DATE | |||
PICKUP_DATE_HI | DATE | |||
DROPOFF_DATE_LO | DATE | |||
DROPOFF_DATE_HI | DATE | |||
PLANNED_FLAG | VARCHAR2 | (1) | ||
SELECTED_BATCH_ID | NUMBER | |||
TASK_PLANNING_FLAG | VARCHAR2 | (1) | ||
APPEND_FLAG | VARCHAR2 | (1) | ||
REGION_ID | NUMBER | |||
ZONE_ID | NUMBER | |||
CATEGORY_ID | NUMBER | |||
CATEGORY_SET_ID | NUMBER | |||
AC_DELIVERY_CRITERIA | VARCHAR2 | (2) | ||
REL_SUBINVENTORY | VARCHAR2 | (10) | ||
SHIP_SET_SMC_FLAG | VARCHAR2 | (1) | ||
TASK_PRIORITY | NUMBER | |||
ALLOCATION_METHOD | VARCHAR2 | (1) | ||
CROSSDOCK_CRITERIA_ID | NUMBER | |||
ACTUAL_DEPARTURE_DATE | DATE | |||
DYNAMIC_REPLENISHMENT_FLAG | VARCHAR2 | (1) | ||
CLIENT_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, NAME
, BACKORDERS_ONLY_FLAG
, DOCUMENT_SET_ID
, EXISTING_RSVS_ONLY_FLAG
, SHIPMENT_PRIORITY_CODE
, SHIP_METHOD_CODE
, CARRIER_ID
, CUSTOMER_ID
, SHIP_TO_LOCATION_ID
, ORDER_HEADER_ID
, ORDER_LINE_ID
, SHIP_SET_NUMBER
, INVENTORY_ITEM_ID
, ORDER_TYPE_ID
, FROM_REQUESTED_DATE
, TO_REQUESTED_DATE
, FROM_SCHEDULED_SHIP_DATE
, TO_SCHEDULED_SHIP_DATE
, SUBINVENTORY
, SHIP_FROM_LOCATION_ID
, ORGANIZATION_ID
, DEFAULT_STAGE_SUBINVENTORY
, DEFAULT_STAGE_LOCATOR_ID
, PICK_FROM_SUBINVENTORY
, PICK_FROM_LOCATOR_ID
, AUTODETAIL_PR_FLAG
, AUTO_PICK_CONFIRM_FLAG
, TRIP_ID
, TRIP_STOP_ID
, DELIVERY_ID
, DELIVERY_DETAIL_ID
, PICK_GROUPING_RULE_ID
, PICK_SEQUENCE_RULE_ID
, PARTIAL_ALLOWED_FLAG
, INCLUDE_PLANNED_LINES
, AUTOCREATE_DELIVERY_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, PROJECT_ID
, TASK_ID
, AUTO_SEND_DOC_FLAG
, NON_PICKING_FLAG
, SHIP_CONFIRM_RULE_ID
, AUTOPACK_FLAG
, AUTOPACK_LEVEL
, DELIVERY_NAME_LO
, DELIVERY_NAME_HI
, BOL_NUMBER_LO
, BOL_NUMBER_HI
, INTMED_SHIP_TO_LOC_ID
, POOLED_SHIP_TO_LOC_ID
, FOB_CODE
, FREIGHT_TERMS_CODE
, PICKUP_DATE_LO
, PICKUP_DATE_HI
, DROPOFF_DATE_LO
, DROPOFF_DATE_HI
, PLANNED_FLAG
, SELECTED_BATCH_ID
, TASK_PLANNING_FLAG
, APPEND_FLAG
, REGION_ID
, ZONE_ID
, CATEGORY_ID
, CATEGORY_SET_ID
, AC_DELIVERY_CRITERIA
, REL_SUBINVENTORY
, SHIP_SET_SMC_FLAG
, TASK_PRIORITY
, ALLOCATION_METHOD
, CROSSDOCK_CRITERIA_ID
, ACTUAL_DEPARTURE_DATE
, DYNAMIC_REPLENISHMENT_FLAG
, CLIENT_ID
FROM WSH.WSH_PICKING_BATCHES#;
|
|
|