mugs

delete POs with missing edocs

Aug 10th, 2015
268
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.20 KB | None | 0 0
  1. DELETE
  2. FROM
  3. pur_po_t
  4. WHERE
  5. FDOC_NBR IN
  6. (
  7.   SELECT
  8.   po.FDOC_NBR
  9.   FROM
  10.   pur_po_t po
  11.   left join
  12.   krew_doc_hdr_t hdr ON
  13.   hdr.doc_hdr_id=po.FDOC_NBR
  14.   WHERE
  15.   hdr.doc_hdr_id IS NULL
  16. )
Advertisement
Add Comment
Please, Sign In to add comment