Best discount percentage calculation through pricing algorithm in oracle Fusion Pricing

Hi,

Our requirement is to have Best discount percentage calculation on the sales order line.

we have one pricing strategy which has multiple discount lists assigned. We need pricing algorithm to check all the discount lists under the applied pricing strategy and chose the maximum discount percentage among all the eligible discount lines.

The logic is to be as follows:

1. Get the pricing strategy which is applied on the SO Line
2. Fetch all the eligible discount lines under multiple discount lists in that pricing strategy (Can be discount percent or Price Override)
3. If there is a discount line with value 0, then apply 0