FND Design Data [Home] [Help]

View: WSHBV_PICK_RELEASE_RULE

Product: OE - Order Entry
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.WSHBV_PICK_RELEASE_RULE
View Text

SELECT SPR.PICKING_RULE
, SPR.CREATION_DATE
, SPR.CREATED_BY
, SPR.LAST_UPDATE_DATE
, SPR.LAST_UPDATED_BY
, SPR.LAST_UPDATE_LOGIN
, SPR.PROGRAM_APPLICATION_ID
, SPR.PROGRAM_ID
, SPR.PROGRAM_UPDATE_DATE
, SPR.REQUEST_ID
, SPR.BACKORDERS_ONLY_FLAG
, SPR.SHIPMENT_PRIORITY_CODE
, SPR.HEADER_ID
, SPR.ORDER_TYPE_ID
, SPR.WAREHOUSE_ID
, SPR.CUSTOMER_ID
, SPR.SITE_USE_ID
, SPR.SHIP_METHOD_CODE
, SPR.GROUP_ID
, SPR.SUBINVENTORY
, SPR.SHIP_SET_NUMBER
, SPR.INVENTORY_ITEM_ID
, SPR.DATE_REQUESTED_FROM
, SPR.DATE_REQUESTED_TO
, SPR.SCHEDULED_SHIPMENT_DATE_FROM
, SPR.SCHEDULED_SHIPMENT_DATE_TO
, SPR.START_DATE_ACTIVE
, SPR.END_DATE_ACTIVE
, SPR.EXISTING_RSVS_ONLY_FLAG
, SPR.PICK_SLIP_RULE_ID
, SPR.RELEASE_SEQ_RULE_SET_ID
, SPR.PARTIAL_ALLOWED_FLAG
, SPR.INCLUDE_PLANNED_LINES_FLAG
, SPR.AUTOCREATE_DELIVERY_FLAG
FROM SO_PICKING_RULES SPR

Columns

Name
PICKING_RULE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
REQUEST_ID
BACKORDERS_ONLY_FLAG
SHIPMENT_PRIORITY_CODE
HEADER_ID
ORDER_TYPE_ID
WAREHOUSE_ID
CUSTOMER_ID
SITE_USE_ID
SHIP_METHOD_CODE
GROUP_ID
SUBINVENTORY
SHIP_SET_NUMBER
INVENTORY_ITEM_ID
DATE_REQUESTED_FROM
DATE_REQUESTED_TO
SCHEDULED_SHIPMENT_DATE_FROM
SCHEDULED_SHIPMENT_DATE_TO
START_DATE_ACTIVE
END_DATE_ACTIVE
EXISTING_RSVS_ONLY_FLAG
PICK_SLIP_RULE_ID
RELEASE_SEQ_RULE_SET_ID
PARTIAL_ALLOWED_FLAG
INCLUDE_PLANNED_LINES_FLAG
AUTOCREATE_DELIVERY_FLAG