A definition and test data for businessunitbase would be helpful.

Couldn't you just left join the table businessunitbase to itself?

I see Lynn, but I'll take my chances for now.
WITH CTE AS
  (SELECT A.BUSINESS_UNIT, A.PO_ID, A.PO_TYPE, A.PO_STATUS,
   (CONVERT(CHAR(10),A.PO_DT,121)) AS PO_DT,
  ...

I modified the SQL I posted, I didn't want to take the time to reformat your last post.

With out test data it's hard to say, but try this: (ALWAYS post your code within the SQL code tags)  I removed a bunch of columns in your group by...

Looking at your results from (Alias 'CTE') the reason you are not getting one row per requestor is the 'Line_NBR' column.
It doesn't look like you are using that field...

Cast Sequence# as a char and don't convert member# to an int to get around this. At least that's what I would do.  There is no FROM in your CTE,...

Just need a place to vent this... I was searching for a room on a major hotel chains website, I entered the dates as March 30, 2019 through April 6. ...