[Home] [Help] [Dependency Information]
Object Name: | WSH_PICKING_RULES |
---|---|
Object Type: | TABLE |
Owner: | WSH |
FND Design Data: | WSH.WSH_PICKING_RULES |
Subobject Name: | |
Status: | VALID |
WSH_PICKING_RULES has picking rules for defaulting Pick Release options.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WSH_PICKING_RULES_U1 | NORMAL | UNIQUE | APPS_TS_SEED | PICKING_RULE_ID |
WSH_PICKING_RULES_U2 | NORMAL | UNIQUE | APPS_TS_SEED | NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PICKING_RULE_ID | NUMBER | Yes | Primary key for picking rule | |
NAME | VARCHAR2 | (20) | Yes | Rule text name |
DOCUMENT_SET_ID | NUMBER | Document set | ||
BACKORDERS_ONLY_FLAG | VARCHAR2 | (1) | Yes | Indicator of wether batch contains unreleased or backordered order lines, or both |
SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | Shipment priority | |
ORDER_HEADER_ID | NUMBER | Order Header | ||
ORDER_TYPE_ID | NUMBER | Order type | ||
SHIP_FROM_LOCATION_ID | NUMBER | Ship From Location | ||
ORGANIZATION_ID | NUMBER | Warehouse 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 from | |
PICK_FROM_LOCATOR_ID | NUMBER | Locator to pick release from | ||
AUTODETAIL_PR_FLAG | VARCHAR2 | (1) | Indicator whether automatically detail | |
AUTO_PICK_CONFIRM_FLAG | VARCHAR2 | (1) | Indicator whether automatically pick confirm | |
CUSTOMER_ID | NUMBER | Customer to receive the shipment | ||
SHIP_TO_LOCATION_ID | NUMBER | Ship-to location | ||
SHIP_METHOD_CODE | VARCHAR2 | (30) | Ship method | |
CARRIER_ID | NUMBER | Freight carrier | ||
SUBINVENTORY | VARCHAR2 | (10) | Subinventory | |
SHIP_SET_NUMBER | NUMBER | Ship set | ||
INVENTORY_ITEM_ID | NUMBER | Inventory item | ||
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 | ||
START_DATE_ACTIVE | DATE | Date this record becomes active | ||
END_DATE_ACTIVE | DATE | Date this record becomes inactive | ||
EXISTING_RSVS_ONLY_FLAG | VARCHAR2 | (1) | Indicate whether to release existing reservations | |
PICK_GROUPING_RULE_ID | NUMBER | Identifier of the associated pick slip | ||
PICK_SEQUENCE_RULE_ID | NUMBER | Identifier of the associated release sequence rule | ||
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) | Automatically create deliveries | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
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 | ||
SHIP_CONFIRM_RULE_ID | NUMBER | Foreign key to WSH_SHIP_CONFIRM_RULES | ||
AUTOPACK_FLAG | VARCHAR2 | (1) | Autopack Deliveryes (Y=Yes,NULL=N) | |
AUTOPACK_LEVEL | NUMBER | Level of autopacking | ||
TASK_PLANNING_FLAG | VARCHAR2 | (1) | Task Planning Flag for Warehouse Management System | |
APPEND_FLAG | VARCHAR2 | (1) | Append flag for Delivery Consolidation (NULL=shipping parameters, N =not append deliveries, Y = append deliveries) | |
SCH_START_DAYS | NUMBER | Scheduled start days | ||
SCH_START_HOURS | NUMBER | Scheduled start hours | ||
SCH_END_DAYS | NUMBER | Scheduled end days | ||
SCH_END_HOURS | NUMBER | Scheduled end hours | ||
REQ_START_DAYS | NUMBER | Requested start days | ||
REQ_START_HOURS | NUMBER | Requested start hours | ||
REQ_END_DAYS | NUMBER | Requested end days | ||
REQ_END_HOURS | NUMBER | Requested end hours | ||
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 critieria | |
REL_SUBINVENTORY | VARCHAR2 | (10) | Subinventory to release | |
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. | ||
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 PICKING_RULE_ID
, NAME
, DOCUMENT_SET_ID
, BACKORDERS_ONLY_FLAG
, SHIPMENT_PRIORITY_CODE
, ORDER_HEADER_ID
, ORDER_TYPE_ID
, 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
, CUSTOMER_ID
, SHIP_TO_LOCATION_ID
, SHIP_METHOD_CODE
, CARRIER_ID
, SUBINVENTORY
, SHIP_SET_NUMBER
, INVENTORY_ITEM_ID
, FROM_REQUESTED_DATE
, TO_REQUESTED_DATE
, FROM_SCHEDULED_SHIP_DATE
, TO_SCHEDULED_SHIP_DATE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, EXISTING_RSVS_ONLY_FLAG
, 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
, SHIP_CONFIRM_RULE_ID
, AUTOPACK_FLAG
, AUTOPACK_LEVEL
, TASK_PLANNING_FLAG
, APPEND_FLAG
, SCH_START_DAYS
, SCH_START_HOURS
, SCH_END_DAYS
, SCH_END_HOURS
, REQ_START_DAYS
, REQ_START_HOURS
, REQ_END_DAYS
, REQ_END_HOURS
, REGION_ID
, ZONE_ID
, CATEGORY_ID
, CATEGORY_SET_ID
, AC_DELIVERY_CRITERIA
, REL_SUBINVENTORY
, TASK_PRIORITY
, ALLOCATION_METHOD
, CROSSDOCK_CRITERIA_ID
, DYNAMIC_REPLENISHMENT_FLAG
, CLIENT_ID
FROM WSH.WSH_PICKING_RULES;
WSH.WSH_PICKING_RULES does not reference any database object
WSH.WSH_PICKING_RULES is referenced by following:
|
|
|