Can I get a report on Sales scheduled processes using an SQL query?

Yes, you can query the following application tables to create a report on scheduled (ESS) processes: FUSION_ORA_ESS.REQUEST_HISTORY and FUSION_ORA_ESS.REQUEST_PROPERTY.