Database views for request item software request approvals

[BH14]

I've been working on creating a database view for software approval requests. 

I'm trying to specifically report on request item approvals (regardless of state) for Software Requests. 

Can someone help me if there something I need to fix with the database view that I've created in my PDI?

[BH14]

I think I need to revamp the entire database view. 

I'm not able to dot walk at all on the request item records, so maybe that is something me and my team can look into instead.