VIEW: APPS.WSHBV_PICKING_BATCH

Source

View Text - Preformatted

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

View Text - HTML Formatted

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