22: NOT EXISTS
23: (SELECT
24: 'OPEN/PENDING PICK SLIP EXISTS'
25: FROM
26: SO_PICKING_LINES PL, SO_PICKING_HEADERS PH
27: WHERE
28: PL.ORDER_LINE_ID = O_LINE_ID AND
29: PH.PICKING_HEADER_ID = PL.PICKING_HEADER_ID AND
30: PH.STATUS_CODE || '' IN ('OPEN', 'PENDING'))
49: AND NOT EXISTS
50: (SELECT
51: 'BACKORDERED PICKING LINES'
52: FROM
53: SO_PICKING_LINES PL
54: WHERE
55: PL.ORDER_LINE_ID = O_LINE_ID AND
56: PL.PICKING_HEADER_ID+0 = 0 AND
57: NVL(PL.CANCELLED_QUANTITY, 0) < PL.REQUESTED_QUANTITY);