Advertisement
mugs

drop non existent capital asset items

Apr 27th, 2017
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.28 KB | None | 0 0
  1. DELETE
  2. FROM
  3. PUR_PO_CPTL_AST_ITM_T
  4. WHERE
  5. CPTL_AST_ITM_ID IN (
  6.   SELECT
  7.   aitm.CPTL_AST_ITM_ID
  8.   FROM
  9.   PUR_PO_CPTL_AST_ITM_T aitm
  10.   left outer join pur_po_itm_t pitm ON
  11.   aitm.FDOC_NBR = pitm.FDOC_NBR
  12.   AND
  13.   aitm.PO_ITM_ID = pitm.PO_ITM_ID
  14.   WHERE
  15.   pitm.FDOC_NBR IS NULL
  16. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement