APPS.WSH_PICK_LIST dependencies on WSH_EXCEPTIONS

Line 3728: select '1' from wsh_exceptions we where

3724: wnd.batch_id = c_sc_batch_id AND
3725: wtp.trip_id = wst.trip_id AND
3726: wst.status_code = 'OP' AND
3727: NOT EXISTS (
3728: select '1' from wsh_exceptions we where
3729: we.delivery_id = wnd.delivery_id AND
3730: we.severity = 'ERROR' AND
3731: we.status = 'OPEN' AND
3732: we.EXCEPTION_NAME = 'WSH_SC_REQ_EXPORT_COMPL')

Line 3750: select '1' from wsh_exceptions we where

3746: wnd.batch_id = c_sc_batch_id and
3747: wst.trip_id = wtp.trip_id and
3748: wst.status_code = 'OP' AND
3749: NOT EXISTS (
3750: select '1' from wsh_exceptions we where
3751: we.delivery_id = wnd.delivery_id AND
3752: we.severity = 'ERROR' AND
3753: we.status = 'OPEN' AND
3754: we.EXCEPTION_NAME = 'WSH_SC_REQ_EXPORT_COMPL')

Line 3769: select '1' from wsh_exceptions we where

3765: wnd2.batch_id = c_sc_batch_id and
3766: wst2.trip_id = wtp2.trip_id and
3767: wst2.status_code = 'OP' AND
3768: NOT EXISTS (
3769: select '1' from wsh_exceptions we where
3770: we.delivery_id = wnd2.delivery_id AND
3771: we.severity = 'ERROR' AND
3772: we.status = 'OPEN' AND
3773: we.EXCEPTION_NAME = 'WSH_SC_REQ_EXPORT_COMPL'))