APPS.QA_ERES_SHIPPING SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 76

	SELECT wnd.delivery_id, wnd.name
	FROM wsh_new_deliveries wnd
	WHERE wnd.initial_pickup_date >= c_from_date
	AND wnd.initial_pickup_date <= c_to_date
	AND (wnd.status_code = 'IT' OR wnd.status_code = 'CL')
        AND nvl(wnd.shipment_direction, 'O') in ('O') --BUG 3763874
	AND NOT EXISTS
		(SELECT 1
		 FROM EDR_PSIG_DOCUMENTS epd
		 WHERE epd.event_name = c_evt_name
		 AND epd.event_key = wnd.delivery_id
		 AND epd.psig_status = 'COMPLETE');