1 Reply Latest reply: Sep 4, 2012 5:10 AM by Pradeep Kalyan RSS

    Oracle Approval Management for Quotes

    ndg
      Hi,

      When a sales representative creates a quote the quote should go to his manager for approval.
      That is it should follow the sales group hierarchy for approval .
      I have created a approver group with dynamic query :
      select distinct 'person_id:'||qrslt.source_id from (SELECT g.group_name, g.GROUP_ID, g.parent_group_id,
      gvl.start_date_active, gvl.end_date_active,
      RS.RESOURCE_NAME,
      GVL.GROUP_DESC,
      MR.RESOURCE_ID,
      rs.source_id
      FROM (SELECT group_name, GROUP_ID, parent_group_id
      FROM jtf_rs_grp_denorm_vl
      WHERE denorm_level = 1
      ) g,
      jtf_rs_group_mbr_role_vl mr,
      JTF_RS_RESOURCE_EXTNS_VL RS,
      jtf_rs_groups_vl gvl,aso_quote_headers_all aqh
      WHERE mr.GROUP_ID = g.GROUP_ID
      AND gvl.GROUP_ID = g.GROUP_ID
      AND mr.resource_id = rs.resource_id
      and MR.MANAGER_FLAG = 'Y'
      and G.GROUP_ID=AQH.RESOURCE_GRP_ID
      and AQH.QUOTE_HEADER_ID = :transactionId
      )qrslt

      How to attach it to action type as when I test it no approvers are shown.