View: WSHFV_PICKING_BATCH

View Text

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
, OGF.DESCRIPTION FREIGHT
, SPB.CUSTOMER_ID
, RC.CUSTOMER_NAME
, SPB.GROUP_ID
, SIG.NAME ITEM_GROUP_NAME
, SPB.HEADER_ID
, SH.ORDER_NUMBER
, SPB.SHIP_SET_NUMBER
, SPB.INVENTORY_ITEM_ID
, MSI.DESCRIPTION
, SPB.ORDER_TYPE_ID
, SOT.NAME ORDER_TYPE_NAME
, SPB.DATE_REQUESTED_FROM
, SPB.DATE_REQUESTED_TO
, SPB.SCHEDULED_SHIPMENT_DATE_FROM
, SPB.SCHEDULED_SHIPMENT_DATE_TO
, SPB.SITE_USE_ID
, SU.LOCATION SHIP_TO
, SPB.WAREHOUSE_ID
, ORG.ORGANIZATION_CODE ORGANIZATION_CODE
, SPB.SUBINVENTORY
, SPB.DATE_RELEASED RELEASED_DATE
, SPB.ORG_ID
, HOU.NAME ORG_NAME
, SPB.DEPARTURE_ID
, WDP.NAME DEPARTURE_NAME
, SPB.DELIVERY_ID
, WDL.NAME DELIVERY_NAME
, SPB.PICK_SLIP_RULE_ID
, WPSR.NAME PICK_SLIP_RULE_NAME
, SPB.RELEASE_SEQ_RULE_ID
, WRSR.NAME RELEASE_SEQUENCE_RULE_NAME
, SPB.PARTIAL_ALLOWED_FLAG
, SPB.INCLUDE_PLANNED_LINES
FROM SO_PICKING_BATCHES_ALL SPB
, MTL_SYSTEM_ITEMS MSI
, ORG_FREIGHT OGF
, RA_CUSTOMERS RC
, WSH_DEPARTURES WDP
, WSH_DELIVERIES WDL
, SO_HEADERS_ALL SH
, SO_ITEM_GROUPS SIG
, SO_ORDER_TYPES_ALL SOT
, WSH_PICK_SLIP_RULES WPSR
, WSH_RELEASE_SEQ_RULES WRSR
, RA_SITE_USES_ALL SU
, MTL_PARAMETERS ORG
, HR_ALL_ORGANIZATION_UNITS HOU
WHERE MSI.INVENTORY_ITEM_ID (+) = SPB.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID (+) = SPB.WAREHOUSE_ID
AND OGF.FREIGHT_CODE (+) = SPB.SHIP_METHOD_CODE
AND OGF.ORGANIZATION_ID (+) = SPB.WAREHOUSE_ID
AND RC.CUSTOMER_ID (+) = SPB.CUSTOMER_ID
AND WDP.DEPARTURE_ID (+) = SPB.DEPARTURE_ID
AND WDL.DELIVERY_ID (+) = SPB.DELIVERY_ID
AND SH.HEADER_ID(+) = SPB.HEADER_ID
AND SIG.GROUP_ID (+) = SPB.GROUP_ID
AND SOT.ORDER_TYPE_ID (+) = SPB.ORDER_TYPE_ID
AND WPSR.PICK_SLIP_RULE_ID (+) = SPB.PICK_SLIP_RULE_ID
AND WRSR.RELEASE_SEQ_RULE_ID(+) = SPB.RELEASE_SEQ_RULE_ID
AND SU.SITE_USE_ID (+)= SPB.SITE_USE_ID
AND ORG.ORGANIZATION_ID (+) = SPB.WAREHOUSE_ID
AND HOU.ORGANIZATION_ID (+) = SPB.ORG_ID

Columns