[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | WSH_PICKING_BATCHES |
|---|---|
| Object Type: | TABLE |
| Owner: | WSH |
| FND Design Data: |  WSH.WSH_PICKING_BATCHES
|
| Subobject Name: | |
| Status: | VALID |
WSH_PICKING_BATCHES has the batches for Pick Release.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| WSH_PICKING_BATCHES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 BATCH_ID
|
| WSH_PICKING_BATCHES_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
NAME
|
| WSH_PICKING_BATCHES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUSTOMER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BATCH_ID | NUMBER | Yes | Primary key | |
| NAME | VARCHAR2 | (30) | Yes | Unique batch name |
| BACKORDERS_ONLY_FLAG | VARCHAR2 | (1) | Indicator of whether batch contains unreleased or backordered order line, or both | |
| DOCUMENT_SET_ID | NUMBER | Document set | ||
| EXISTING_RSVS_ONLY_FLAG | VARCHAR2 | (1) | Indicate whether to release existing reservations | |
| SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | Shipment priority | |
| SHIP_METHOD_CODE | VARCHAR2 | (30) | Ship method | |
| CARRIER_ID | NUMBER | Freight carrier | ||
| CUSTOMER_ID | NUMBER | Customer to receive the shipment | ||
| SHIP_TO_LOCATION_ID | NUMBER | Ship-to location | ||
| ORDER_HEADER_ID | NUMBER | Order header identifier | ||
| ORDER_LINE_ID | NUMBER | Order line identifier | ||
| SHIP_SET_NUMBER | NUMBER | ship set | ||
| INVENTORY_ITEM_ID | NUMBER | Inventory item | ||
| ORDER_TYPE_ID | NUMBER | Order type | ||
| FROM_REQUESTED_DATE | DATE | Starting request date to release | ||
| TO_REQUESTED_DATE | DATE | Ending request date to release | ||
| FROM_SCHEDULED_SHIP_DATE | DATE | Starting schedule date to release | ||
| TO_SCHEDULED_SHIP_DATE | DATE | Ending schedule date to release | ||
| SUBINVENTORY | VARCHAR2 | (10) | Subinventory | |
| SHIP_FROM_LOCATION_ID | NUMBER | Ship from location | ||
| ORGANIZATION_ID | NUMBER | Organization to ship from | ||
| DEFAULT_STAGE_SUBINVENTORY | VARCHAR2 | (10) | Default subinventory to stage to | |
| DEFAULT_STAGE_LOCATOR_ID | NUMBER | Default locator to stage to | ||
| PICK_FROM_SUBINVENTORY | VARCHAR2 | (10) | Subinventory to pick release | |
| PICK_FROM_LOCATOR_ID | NUMBER | Locator to pick release from | ||
| AUTODETAIL_PR_FLAG | VARCHAR2 | (1) | Indicator when to automatically detail | |
| AUTO_PICK_CONFIRM_FLAG | VARCHAR2 | (1) | Indicator whether to automatically pick confirm | |
| TRIP_ID | NUMBER | Trip identifier | ||
| TRIP_STOP_ID | NUMBER | Stop identifier | ||
| DELIVERY_ID | NUMBER | Delivery identifier | ||
| DELIVERY_DETAIL_ID | NUMBER | Delivery detail identifier | ||
| PICK_GROUPING_RULE_ID | NUMBER | Foreign key to WSH_PICK_GROUPING_RULES | ||
| PICK_SEQUENCE_RULE_ID | NUMBER | Foreign key to WSH_PICK_SEQUENCE_RULES | ||
| PARTIAL_ALLOWED_FLAG | VARCHAR2 | (1) | Permit partial release quantities | |
| INCLUDE_PLANNED_LINES | VARCHAR2 | (1) | Include planned lines in pick release | |
| AUTOCREATE_DELIVERY_FLAG | VARCHAR2 | (1) | Indicate whether deliveries were created during pick release | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
| PROGRAM_ID | NUMBER | Standard Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
| REQUEST_ID | NUMBER | Standard Who column | ||
| PROJECT_ID | NUMBER | Project identifier | ||
| TASK_ID | NUMBER | Task identifier | ||
| AUTO_SEND_DOC_FLAG | VARCHAR2 | (1) | Auto Send Document Flag (Y - trigger outbound document request) | |
| NON_PICKING_FLAG | VARCHAR2 | (1) | Non-picking Flag (NULL = Pick Release Batch, Y = Not Pick Release Batch) | |
| SHIP_CONFIRM_RULE_ID | NUMBER | Foreign key to WSH_SHIP_CONFIRM_RULES (non-NULL means Ship Confirm Batch) | ||
| AUTOPACK_FLAG | VARCHAR2 | (1) | Autopack Deliveries (Y=Yes,N=No;NULL=No; Y means Autopack Batch) | |
| AUTOPACK_LEVEL | NUMBER | Level of Autopacking (1=Autopack,2=Autopack Master) | ||
| DELIVERY_NAME_LO | VARCHAR2 | (30) | Automation data criteria: Low Delivery Name | |
| DELIVERY_NAME_HI | VARCHAR2 | (30) | Automation data criteria: High Delivery Name | |
| BOL_NUMBER_LO | VARCHAR2 | (50) | Automation data criteria: Low BOL Number | |
| BOL_NUMBER_HI | VARCHAR2 | (50) | Automation data criteria: High BOL Number | |
| INTMED_SHIP_TO_LOC_ID | NUMBER | Automation data criteria: Intermediate Ship To Location | ||
| POOLED_SHIP_TO_LOC_ID | NUMBER | Automation data criteria: Pooled Ship To Location | ||
| FOB_CODE | VARCHAR2 | (30) | Automation data criteria: FOB | |
| FREIGHT_TERMS_CODE | VARCHAR2 | (30) | Automation data criteria: Freight Terms | |
| PICKUP_DATE_LO | DATE | Automation data criteria: Low Pick-up Date | ||
| PICKUP_DATE_HI | DATE | Automation data criteria: High Pick-up Date | ||
| DROPOFF_DATE_LO | DATE | Automation data criteria: Low Drop-off Date | ||
| DROPOFF_DATE_HI | DATE | Automation data criteria: High Drop-off Date | ||
| PLANNED_FLAG | VARCHAR2 | (1) | Automation data criteria: Planned | |
| SELECTED_BATCH_ID | NUMBER | Automation data criteria: Batch | ||
| TASK_PLANNING_FLAG | VARCHAR2 | (1) | Task Planning Flag for Warehouse Management System | |
| APPEND_FLAG | VARCHAR2 | (1) | Append Delivery Flag | |
| REGION_ID | NUMBER | Region identifier | ||
| ZONE_ID | NUMBER | Zone identifier | ||
| CATEGORY_ID | NUMBER | Category identifier | ||
| CATEGORY_SET_ID | NUMBER | Category set identifier | ||
| AC_DELIVERY_CRITERIA | VARCHAR2 | (2) | Autocreate Delivery criteria | |
| REL_SUBINVENTORY | VARCHAR2 | (10) | Subinventory to release | |
| SHIP_SET_SMC_FLAG | VARCHAR2 | (1) | Possible values E = Exclude ShipSets/SMCs, I = Include Only ShipSets/SMCs and A /NULL = Process All | |
| TASK_PRIORITY | NUMBER | controls WMS picking by task priority; the higher the value is, the higher priority the task is. | ||
| ALLOCATION_METHOD | VARCHAR2 | (1) | Method to allocate items: possible values - I, C, N, X | |
| CROSSDOCK_CRITERIA_ID | NUMBER | Crossdock criteria is used to allocate items from cross dock. | ||
| ACTUAL_DEPARTURE_DATE | DATE | Actual Departure Date | ||
| DYNAMIC_REPLENISHMENT_FLAG | VARCHAR2 | (1) | To indicate whether dynamic replenishment is selected or not. | |
| CLIENT_ID | NUMBER | Client Id |
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;
WSH.WSH_PICKING_BATCHES does not reference any database object
WSH.WSH_PICKING_BATCHES is referenced by following:
WSH
WSH_PICKING_BATCHES#
|
|
|
|