279: DISTINCT
280: ( WDD.CUSTOMER_DOCK_CODE )
281: FROM
282: WSH_DELIVERY_DETAILS WDD,
283: WSH_DELIVERY_ASSIGNMENTS_V WDA
284: WHERE WDA.DELIVERY_ID = DELIVERY_ID3
285: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
286: AND NVL(WDD.CONTAINER_FLAG
287: ,'N') = 'N'
452: WHERE WDD.DELIVERY_DETAIL_ID IN (
453: SELECT
454: WDA.DELIVERY_DETAIL_ID
455: FROM
456: WSH_DELIVERY_ASSIGNMENTS WDA
457: START WITH WDA.DELIVERY_DETAIL_ID = C_DELIVERY_DETAIL_ID
458: CONNECT BY prior WDA.DELIVERY_DETAIL_ID = WDA.PARENT_DELIVERY_DETAIL_ID )
459: AND WDD.CONTAINER_FLAG = 'N';
460: BEGIN
487: WDD.SOURCE_LINE_ID,
488: WDD.TOP_MODEL_LINE_ID
489: FROM
490: WSH_DELIVERY_DETAILS WDD,
491: WSH_DELIVERY_ASSIGNMENTS WDA
492: WHERE WDA.DELIVERY_ID = C_DELIVERY_ID
493: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
494: AND WDD.INVENTORY_ITEM_ID = C_INV_ITEM_ID
495: AND WDD.ORGANIZATION_ID = C_INV_ORG_ID