Advertisement
mugs

show POs with missing edocs

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