[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | WSH_PICK_GROUPING_RULES |
|---|---|
| Object Type: | TABLE |
| Owner: | WSH |
| FND Design Data: |  WSH.WSH_PICK_GROUPING_RULES
|
| Subobject Name: | |
| Status: | VALID |
WSH_PICK_GROUPING_RULES has grouping rules for Pick Release.
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| WSH_PICK_GROUPING_RULES_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
 PICK_GROUPING_RULE_ID
|
| WSH_PICK_GROUPING_RULES_U2 | NORMAL | UNIQUE |
APPS_TS_SEED
|
NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PICK_GROUPING_RULE_ID | NUMBER | Yes | Primary Key for pick grouping rule | |
| NAME | VARCHAR2 | (30) | Yes | Rule text name |
| DESCRIPTION | VARCHAR2 | (240) | Description of rule | |
| ORDER_NUMBER_FLAG | VARCHAR2 | (1) | Group pick slip by orders | |
| SUBINVENTORY_FLAG | VARCHAR2 | (1) | Group pick slips by subinventory | |
| CUSTOMER_FLAG | VARCHAR2 | (1) | Group pick slips by customer | |
| SHIP_TO_FLAG | VARCHAR2 | (1) | Group pick slips by ship-to address | |
| CARRIER_FLAG | VARCHAR2 | (1) | Group pick slips by carrier | |
| SHIPMENT_PRIORITY_FLAG | VARCHAR2 | (1) | Group pick slips by shipment priority | |
| TRIP_STOP_FLAG | VARCHAR2 | (1) | Group pick slips by stop | |
| DELIVERY_FLAG | VARCHAR2 | (1) | Group pick slips by delivery | |
| START_DATE_ACTIVE | DATE | Yes | Date rule starts being active | |
| END_DATE_ACTIVE | DATE | Date rule stops being active | ||
| 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 | ||
| PICK_METHOD | VARCHAR2 | (30) | Pick method for rule | |
| ITEM_FLAG | VARCHAR2 | (1) | Group pick slips by item | |
| LOCATOR_FLAG | VARCHAR2 | (1) | Group pick slips by locator | |
| LOT_FLAG | VARCHAR2 | (1) | Group pick slips by lot number | |
| REVISION_FLAG | VARCHAR2 | (1) | Group pick slips by revision | |
| JOB_SCHEDULE_FLAG | VARCHAR2 | (1) | Group pick slips by job or schedule | |
| OPERATION_FLAG | VARCHAR2 | (1) | Group pick slips by operation sequence | |
| DEPARTMENT_FLAG | VARCHAR2 | (1) | Group pick slips by department | |
| PUSH_VS_PULL_FLAG | VARCHAR2 | (1) | Group pick slips by component supply type | |
| DEST_SUB_FLAG | VARCHAR2 | (1) | Group pick slips by destination subinventory | |
| DEST_LOC_FLAG | VARCHAR2 | (1) | Group pick slips by destination locator | |
| PROJECT_FLAG | VARCHAR2 | (1) | Group pick slips by project | |
| TASK_FLAG | VARCHAR2 | (1) | Group pick slips by task | |
| BULK_PICK_CONTROL | NUMBER | Use for bulking tasks together | ||
| USER_DEFINED_FLAG | VARCHAR2 | (1) | Use to distinguish a user-defined rule of bulk picking type from a system defined one. |
Cut, paste (and edit) the following text to query this object:
SELECT PICK_GROUPING_RULE_ID
, NAME
, DESCRIPTION
, ORDER_NUMBER_FLAG
, SUBINVENTORY_FLAG
, CUSTOMER_FLAG
, SHIP_TO_FLAG
, CARRIER_FLAG
, SHIPMENT_PRIORITY_FLAG
, TRIP_STOP_FLAG
, DELIVERY_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, 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
, PICK_METHOD
, ITEM_FLAG
, LOCATOR_FLAG
, LOT_FLAG
, REVISION_FLAG
, JOB_SCHEDULE_FLAG
, OPERATION_FLAG
, DEPARTMENT_FLAG
, PUSH_VS_PULL_FLAG
, DEST_SUB_FLAG
, DEST_LOC_FLAG
, PROJECT_FLAG
, TASK_FLAG
, BULK_PICK_CONTROL
, USER_DEFINED_FLAG
FROM WSH.WSH_PICK_GROUPING_RULES;
WSH.WSH_PICK_GROUPING_RULES does not reference any database object
WSH.WSH_PICK_GROUPING_RULES is referenced by following:
APPS
WSH_PICK_GROUPING_RULES
|
|
|
|