i need some help,my requirement is to send a notification to the cost center owner when a RFQ got cancelled.
so i have created the alert but it is sending the notification to approver but not to cost center owner.
How to achieve this.We have a custom table which stores all the cost center owners,but i am facing the difficulty in joining the tables.
Actually in which table RFQ details will be stored in iProcurement .Currently i am using pon_auction_headers_all .
If the RFQ is from requisitions, check table po_requisition_lines_all to get the AUCTION_HEADER_ID and AUCTION_LINE_NUMBER.