[Home] [Help]
[Dependency Information]
[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. |
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
FROM WSH.WSH_PICKING_RULES;
WSH.WSH_PICKING_RULES does not reference any database object
WSH.WSH_PICKING_RULES is referenced by following:
APPS
WSH_PICKING_RULES
|
|
|
|