Product: | OE - Order Entry |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.WSHBV_PICKING_BATCH |
SELECT SPB.BATCH_ID PICKING_BATCH_ID
, SPB.CREATION_DATE
, SPB.CREATED_BY
, SPB.LAST_UPDATE_DATE
, SPB.LAST_UPDATED_BY
, SPB.LAST_UPDATE_LOGIN
, SPB.PROGRAM_APPLICATION_ID
, SPB.PROGRAM_ID
, SPB.PROGRAM_UPDATE_DATE
, SPB.REQUEST_ID
, SPB.NAME
, SPB.BACKORDERS_ONLY_FLAG
, SPB.EXISTING_RSVS_ONLY_FLAG
, SPB.SHIPMENT_PRIORITY_CODE
, SPB.SHIP_METHOD_CODE
, SPB.CUSTOMER_ID
, SPB.GROUP_ID
, SPB.HEADER_ID
, SPB.SHIP_SET_NUMBER
, SPB.INVENTORY_ITEM_ID
, SPB.ORDER_TYPE_ID
, SPB.DATE_REQUESTED_FROM
, SPB.DATE_REQUESTED_TO
, SPB.SCHEDULED_SHIPMENT_DATE_FROM
, SPB.SCHEDULED_SHIPMENT_DATE_TO
, SPB.SITE_USE_ID
, SPB.WAREHOUSE_ID
, SPB.SUBINVENTORY
, SPB.DATE_RELEASED RELEASED_DATE
, SPB.ORG_ID
, SPB.DEPARTURE_ID
, SPB.DELIVERY_ID
, SPB.PICK_SLIP_RULE_ID
, SPB.RELEASE_SEQ_RULE_ID
, SPB.PARTIAL_ALLOWED_FLAG
, SPB.INCLUDE_PLANNED_LINES
FROM SO_PICKING_BATCHES_ALL SPB