APPS.WSH_PICK_LIST dependencies on WSH_EXCEPTIONS

Line 3816: select '1' from wsh_exceptions we where

3812: wnd.batch_id = c_sc_batch_id AND
3813: wtp.trip_id = wst.trip_id AND
3814: wst.status_code = 'OP' AND
3815: NOT EXISTS (
3816: select '1' from wsh_exceptions we where
3817: we.delivery_id = wnd.delivery_id AND
3818: we.severity = 'ERROR' AND
3819: we.status = 'OPEN' AND
3820: we.EXCEPTION_NAME = 'WSH_SC_REQ_EXPORT_COMPL')

Line 3838: select '1' from wsh_exceptions we where

3834: wnd.batch_id = c_sc_batch_id and
3835: wst.trip_id = wtp.trip_id and
3836: wst.status_code = 'OP' AND
3837: NOT EXISTS (
3838: select '1' from wsh_exceptions we where
3839: we.delivery_id = wnd.delivery_id AND
3840: we.severity = 'ERROR' AND
3841: we.status = 'OPEN' AND
3842: we.EXCEPTION_NAME = 'WSH_SC_REQ_EXPORT_COMPL')

Line 3857: select '1' from wsh_exceptions we where

3853: wnd2.batch_id = c_sc_batch_id and
3854: wst2.trip_id = wtp2.trip_id and
3855: wst2.status_code = 'OP' AND
3856: NOT EXISTS (
3857: select '1' from wsh_exceptions we where
3858: we.delivery_id = wnd2.delivery_id AND
3859: we.severity = 'ERROR' AND
3860: we.status = 'OPEN' AND
3861: we.EXCEPTION_NAME = 'WSH_SC_REQ_EXPORT_COMPL'))