Sql query to map Job Application Flows with Type Request Information to candidate in ORC

Summary:

SQL query to map Job Application Flow with Request More Information Type to Candidate.

Content (please ensure you mask any confidential information):

We have added a RMI to a state, when used Move Application and selected the appropriate phase/state, an RMI is sent to candidate.

We are attempting to write a BI SQL query that has these state's specific actions held on the candidate application page.

Following is the SQL referral query we used:

SELECT
    offer.offer_id
    , candidate.candidate_number
--    , req.*
    , af.apply_flow_name 
FROM
    irc_offers           offer
    , irc_candidates       candidate
    , irc_requisitions_b   req