[Home] [Help]
[Dependency Information]
[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#;
WSH
WSH_PICKING_BATCHES
APPS
WSH_PICKING_BATCHES
|
|
|
|