Need SQL query

Can someone Please help me with SQL Query to list below fields for Oracle (OIP and script based) backups.

master server, Policy, Last_successfull backup,Total_streams,successful_streams,Parent_Job,Parent_status