Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELETE
- FROM
- PUR_PO_CPTL_AST_ITM_T
- WHERE
- CPTL_AST_ITM_ID IN (
- SELECT
- aitm.CPTL_AST_ITM_ID
- FROM
- PUR_PO_CPTL_AST_ITM_T aitm
- left outer join pur_po_itm_t pitm ON
- aitm.FDOC_NBR = pitm.FDOC_NBR
- AND
- aitm.PO_ITM_ID = pitm.PO_ITM_ID
- WHERE
- pitm.FDOC_NBR IS NULL
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement