APPS.WSHBV_PICKING_BATCHES
[Home] [Help]
| Product: | WSH - Shipping Execution |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.WSHBV_PICKING_BATCHES
|
SELECT WPB.BATCH_ID PICKING_BATCH_ID
, WPB.DOCUMENT_SET_ID
, WPB.CARRIER_ID
, LOC.SOURCE_LOCATION_ID
, WPB.ORDER_HEADER_ID
, WPB.ORDER_LINE_ID
, LOC1.SOURCE_LOCATION_ID
, WPB.DEFAULT_STAGE_SUBINVENTORY
, WPB.DEFAULT_STAGE_LOCATOR_ID
, '_KF:INV:MTLL:MIL1'
, WPB.PICK_FROM_SUBINVENTORY
, WPB.PICK_FROM_LOCATOR_ID
, '_KF:INV:MTLL:MIL2'
, '_LA:WPB.AUTODETAIL_PR_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:WPB.AUTO_PICK_CONFIRM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WPB.TRIP_ID
, WPB.TRIP_STOP_ID
, WPB.DELIVERY_ID
, WPB.DELIVERY_DETAIL_ID
, WPB.PICK_GROUPING_RULE_ID
, WPB.PICK_SEQUENCE_RULE_ID
, '_LA:WPB.AUTOCREATE_DELIVERY_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WPB.CREATION_DATE
, WPB.CREATED_BY
, WPB.LAST_UPDATE_DATE
, WPB.LAST_UPDATED_BY
, WPB.NAME
, WPB.BACKORDERS_ONLY_FLAG
, '_LA:WPB.EXISTING_RSVS_ONLY_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:WPB.SHIPMENT_PRIORITY_CODE:FND_LOOKUP_VALUES_VL:SHIPMENT_PRIORITY:MEANING'
, '_LA:WPB.SHIP_METHOD_CODE:FND_LOOKUP_VALUES_VL:SHIP_METHOD:MEANING'
, WPB.CUSTOMER_ID
, WPB.SHIP_SET_NUMBER
, WPB.ORDER_TYPE_ID
, WPB.FROM_REQUESTED_DATE
, WPB.TO_REQUESTED_DATE
, WPB.FROM_SCHEDULED_SHIP_DATE
, WPB.TO_SCHEDULED_SHIP_DATE
, WPB.SUBINVENTORY
, WPB.ORGANIZATION_ID
, '_LA:WPB.PARTIAL_ALLOWED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:WPB.INCLUDE_PLANNED_LINES:FND_LOOKUPS:YES_NO:MEANING'
, WPB.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
FROM WSH_PICKING_BATCHES WPB
, MTL_SYSTEM_ITEMS MSI
, MTL_ITEM_LOCATIONS MIL1
, WSH_LOCATIONS LOC
, WSH_LOCATIONS LOC1
, MTL_ITEM_LOCATIONS MIL2
WHERE WPB.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND WPB.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+)
AND WPB.DEFAULT_STAGE_LOCATOR_ID=MIL1.INVENTORY_LOCATION_ID(+)
AND WPB.ORGANIZATION_ID=MIL1.ORGANIZATION_ID(+)
AND WPB.PICK_FROM_LOCATOR_ID=MIL2.INVENTORY_LOCATION_ID(+)
AND WPB.ORGANIZATION_ID=MIL2.ORGANIZATION_ID(+)
AND WPB.SHIP_TO_LOCATION_ID = LOC.WSH_LOCATION_ID(+)
AND WPB.SHIP_FROM_LOCATION_ID = LOC1.WSH_LOCATION_ID(+)
AND '_SEC:WPB.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY