Query on Extracting Transaction Approval Rule Names for Multiple Rules

Hi Team,

I am currently engaged in a project where we need to extract the names of transaction approval rules from our system. Up to this point, we have been utilizing the table FA_FUSION_SOAINFRA.WFTASK to fetch the rule name associated with each transaction. This approach has been effective for transactions governed by a single rule. However, we've encountered a challenge when a transaction is associated with more than two rules. In such cases, the FA_FUSION_SOAINFRA.WFTASK table only retrieves the name of the latest rule applied, leaving us without access to the names of any previous rules that were also applied to the