3 Replies Latest reply on Aug 4, 2016 10:14 AM by user615979

    Alert to Generate every week from alert manager

    user615979

      Hi,

       

        Working in EBS Version 12.1.3

       

      I need generate to alert every week on thurdays or anyday

       

      please let me know how can i do

       

      this is my query

       

      select ras.name salesrep_name

      ,ac.customer_name

      ,ac.customer_number

      ,sum(ractl.extended_amount) amount

      from ar_customers ac

      ,ra_customer_trx_all rac

      ,ra_customer_trx_lines_all ractl

      ,ra_cust_trx_types_all ctt

      ,jtf_rs_salesreps ras

      where ac.customer_id = rac.bill_to_customer_id

      and rac.customer_trx_id = ractl.customer_trx_id

      and rac.org_id = ractl.org_id

      and rac.cust_trx_type_id = ctt.cust_trx_type_id

      and rac.org_id = ctt.org_id

      and rac.primary_salesrep_id = ras.salesrep_id

      and rac.org_id = ras.org_id

      group by

      ac.customer_name

      ,ac.customer_number

      ,ras.name

       

      Regards