Product: | OE - Order Entry |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.WSHBV_PICK_RELEASE_RULE |
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