APPS.OKE_DSNO_PKG SQL Statements

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

Line: 19

  SELECT w.source_line_id
  FROM wsh_delivery_details w, wsh_delivery_assignments_v a
  WHERE a.delivery_id = p_delivery_id
  AND w.source_code = 'OKE'
  AND w.delivery_detail_id = a.delivery_detail_id
  AND w.source_header_id = p_oke_id;

Line: 63

  SELECT w.source_line_id
  FROM wsh_delivery_details w, wsh_delivery_assignments_v a
  WHERE a.delivery_id = p_delivery_id
  AND w.source_code = 'OKE'
  AND w.delivery_detail_id = a.delivery_detail_id
  AND w.source_header_id = p_oke_id;

Line: 99

    SELECT currency_code
    FROM  oke_k_deliverables_b
    WHERE  deliverable_id=p_deliverable_id;

Line: 104

    SELECT w.source_line_id
    FROM wsh_delivery_details w, wsh_delivery_assignments_v a
    WHERE a.delivery_id = p_delivery_id
    AND w.source_code = 'OKE'
    AND w.delivery_detail_id = a.delivery_detail_id
    AND w.source_header_id = p_oke_id;