Advertisement
yitzyy

Untitled

Nov 15th, 2021
1,238
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CASE WHEN {shipdate} <= {today} THEN
  2. ({amount}-NVL({discountamount},0)/{quantity})*({quantity}-NVL({quantitycommitted},0)-NVL({quantityshiprecv},0)) ELSE 0 END
Advertisement
RAW Paste Data Copied
Advertisement