Create a view in OBIEE 11g by joining all scheduler tables

Hi, I need to create a view by joining the OBIEE scheduler tables which are
S_NQ_JOB, S_NQ_INSTANCE, S_NQ_ERR_MSG, S_NQ_JOB_PARAM. I've tried to link based on JOB_ID, which is common in all tables.
I also need to print the RELATIVE_ORDER grouped by JOB_id, for that I used listagg, but I am unable to do it. Anyone can help me please, I am fighting a lot in this area.

I have uploaded my input data here in SQL format.
https://drive.google.com/file/d/1UVe9BMjaexixxwDFTh5CVNrd4Q4p4ans/view?usp=drivesdk