[Home] [Help] [Dependency Information]
Object Name: | WSHFV_PICK_SLIP_GROUPING_RULES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WSH.WSHFV_PICK_SLIP_GROUPING_RULES |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PICK_SLIP_GROUPING_RULE_ID | NUMBER | Yes | ||
NAME | VARCHAR2 | (30) | Yes | |
DESCRIPTION | VARCHAR2 | (240) | ||
_LA:GROUP_BY_ORDER_FLAG | CHAR | (53) | Group By Order Number Flag | |
_LA:GROUP_BY_SUBINV_FLAG | CHAR | (53) | Group By Subinventory Flag | |
_LA:GROUP_BY_CUST_FLAG | CHAR | (49) | Group By Customer Flag | |
_LA:SHIP_TO_FLAG | CHAR | (48) | Group By Ship To Flag | |
_LA:GROUP_BY_CARRIER_FLAG | CHAR | (48) | Group By Carrier Flag | |
_LA:GROUP_BY_SHIP_PRIORITY | CHAR | (58) | Group By Shipment Priority Flag | |
_LA:GROUP_TRIP_STOP_FLAG | CHAR | (50) | Group By Trip Stop Flag | |
_LA:GROUP_BY_DELIVERY_FLAG | CHAR | (49) | Group By Delivery Flag | |
START_DATE_ACTIVE | DATE | Yes | ||
END_DATE_ACTIVE | DATE | |||
PICK_METHOD | VARCHAR2 | (30) | ||
ITEM_FLAG | VARCHAR2 | (1) | ||
LOCATOR_FLAG | VARCHAR2 | (1) | ||
LOT_FLAG | VARCHAR2 | (1) | ||
REVISION_FLAG | VARCHAR2 | (1) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
_DF | CHAR | (36) | Pick Slip Grouping Rules (Descriptive Flexfield) |
Cut, paste (and edit) the following text to query this object:
SELECT PICK_SLIP_GROUPING_RULE_ID
, NAME
, DESCRIPTION
, _LA:GROUP_BY_ORDER_FLAG
, _LA:GROUP_BY_SUBINV_FLAG
, _LA:GROUP_BY_CUST_FLAG
, _LA:SHIP_TO_FLAG
, _LA:GROUP_BY_CARRIER_FLAG
, _LA:GROUP_BY_SHIP_PRIORITY
, _LA:GROUP_TRIP_STOP_FLAG
, _LA:GROUP_BY_DELIVERY_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, PICK_METHOD
, ITEM_FLAG
, LOCATOR_FLAG
, LOT_FLAG
, REVISION_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, _DF
FROM APPS.WSHFV_PICK_SLIP_GROUPING_RULES;
APPS.WSHFV_PICK_SLIP_GROUPING_RULES is not referenced by any database object
|
|
|