Epicor comes with some Functions which you can use in the BAQ Designer.
I would suggest to add a function GetUserCodeDesc(CodeTypeID, CodeID) which would allow us to create Calculated Fields and just keep the BAQ Clean instead of doing:
Currently: CTE.
Even doing 1 Sub-Query, you can’t re-use it as a SUB-Select. Perhaps a Pivot, with tweaks. Sure this would still be a Sub-Query, but it would be easy to use… a Function in a Calculated Field.
Good or Bad Suggestion idk @Dmitry_Kashulin