R12 : Alert

 Hi,

We are on 12.1.3

We have created a alert after the sales order is booked.

It is working if we create sales order directly i.e without creating the quote.

If we create a quote and convert this quote to sale order alert is not firing ..

The Query :

/* Formatted on 2013/09/24 20:57 (Formatter Plus v4.8.8) */

SELECT ool.sold_to, ooha.order_number, ool.terms,

       SUM (NVL (ool.unit_selling_price, 0) * NVL (ool.ordered_quantity, 0)) OVER (PARTITION BY ool.sold_to, ooha.order_number, ool.terms)

                                                                 order_amount,

       ool.ordered_item, msib.primary_uom_code, ool.ordered_quantity,

       msib.description

  INTO &sold_to, &order_number, &terms,