343: SELECT
344: SUM(NVL(PICKED_QUANTITY
345: ,0))
346: FROM
347: WSH_DELIVERY_DETAILS
348: START WITH DELIVERY_DETAIL_ID = P_DETAIL_ID
349: CONNECT BY prior DELIVERY_DETAIL_ID = SPLIT_FROM_DELIVERY_DETAIL_ID
350: AND SOURCE_HEADER_ID = P_SOURCE_HEADER_ID
351: AND RELEASED_STATUS = 'Y';