I have a query problem.
The query works on the "Test SQL" of the Advanced SQL in Service Studio. In runtime, I am encountering ORA-00918:  column ambiguously defined. Any insights will be of great help! TIA.

Notes: I have tried explicitly calling per column of the entities above and using aliases in the FROM clause to address the columns with the same names (i.e. Id, RequestStatusId, etc.) as per things I found online but it still gives me the error.