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

    Alert to Generate every week from alert manager




        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



      ,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