Advertisement
tko_pb

mo not found

Sep 12th, 2021
1,006
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select ppo.PP_Order_ID from C_Order co join C_OrderLine col on (co.C_Order_ID=col.C_Order_ID and co.DocStatus in ('CO', 'RE', 'VO')) join M_Product mp on (col.M_Product_ID=mp.M_Product_ID) join PP_Order ppo on (ppo.C_OrderLine_ID=col.C_OrderLine_ID and ppo.M_Product_ID=col.M_Product_ID and ppo.DocStatus='CO') where co.AD_Client_ID=1000000 and co.AD_Org_ID=0 and co.IsSOTrx='Y' and co.POReference='0128753152' and mp.Value like '%-104' order by ppo.PP_Order_ID desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement