Hello! I have inherited a "LP_CUSTOMER_RANK" sproc that no longer performs as desired - it is assigning rankings that give discounts to customers not entitled to said discount. It has been through many changes in developers and business practices, and seems mostly made of band-aids at this point. I want to redo it, but at this point it is hard to tell what the current sproc is even doing. Do any of you fine Tessiturians have a "clean" copy of this stored procedure that you'd be willing to share as an example? Many thanks!
Is AP_CUSTOMER_RANK the basis for your LP_CUSTOMER_RANK? If so, that should be in your database.
No, that's the main internal Tessitura procedure that calls LP_CUSTOMER_RANK as part of its execution.