SQL & PL/SQL :: Converting Ref Cursor Into New Table

I am working on a POC. The goal is to do a

select * from function('input')
where the function dynamically returns different tables.

I have gotten to the point where I can return the cursor but I cannot format it as a table to use in the query. It return's it as XML. This is my function:

create or replace
FUNCTION CAMS_FUN_GEN_REPORTS(PARAM1 IN VARCHAR2) RETURN SYS_refCURSOR AS
BEGIN
DECLARE
p_recordset SYS_refCURSOR;
begin
OPEN p_recordset FOR 'SELECT * from STATS_FLAGGED_TOTALS_ME';
RETURN p_recordset;
END;
END CAMS_FUN_GEN_REPORTS;

This is my query:

select * from CAMS_FUN_GEN_REPORTS('')

So normally you would do this

select * from TABLE(CAMS_FUN_GEN_REPORTS('') as tabletype)

But I will never know the end result table as it will be dynamic so I have to find a way to cast the result of the function into a new table I can select on.

I have looked into pipe lining also but from what I can tell you still need to know the table definition. Which I can't know from the client side. The server will control the 'routing' and thus the end result of the select.