Ship conform disable based on sales order amount

 

Condition:

(select sum(ordered_quantity*unit_selling_price)

from oe_order_lines_all oel

,wsh_delivery_details wdd

,wsh_delivery_assignments wda

,wsh_new_deliveries wnd

where 1=1

and wdd.source_line_id = oel.line_id

and wdd.delivery_detail_id = wda.delivery_detail_id

and wda.delivery_id = wnd.delivery_id

and wnd.delivery_id =:DLVY.DELIVERY_ID)<3000