Thankfully these are both easy BAQs to reproduce. For the first one
select
[ECORev].[GroupID] as [ECORev_GroupID],
[ECORev].[PartNum] as [ECORev_PartNum],
[ECORev].[RevisionNum] as [ECORev_RevisionNum],
[ECORev].[CheckedOut] as [ECORev_CheckedOut]
from Erp.ECORev as ECORev
where (ECORev.PartNum = @part and ECORev.RevisionNum = @rev and ECORev.GroupID = @ECOGroup and ECORev.CheckedOut = true)
And for the second one:
select
[PartRev].[RevisionNum] as [PartRev_RevisionNum],
[PartRev].[RevShortDesc] as [PartRev_RevShortDesc]
from Erp.PartRev as PartRev
where (PartRev.PartNum = @part)
As long as you name the BAQs the same, you shouldn’t have to change any code in the BPMs.
Good luck!
Nate