This discussion is archived
1 Reply Latest reply: Sep 4, 2012 3:10 AM by Pradeep Kalyan RSS

Oracle Approval Management for Quotes

ndg Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points