DBA Data[Home] [Help]

APPS.WSH_DSNO_OKE SQL Statements

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

Line: 34

  SELECT a.delivery_id
  FROM wsh_delivery_details w, wsh_delivery_assignments_v a
  WHERE w.delivery_detail_id = p_delivery_detail_id
  AND w.source_code = 'OKE'
  AND w.delivery_detail_id = a.delivery_detail_id;