25C - End Date Offer Assignments for Abandoned Offers

Summary:

Hello Oracle Team,

We are testing this new feature came in 25C - End Date Offer Assignments for Abandoned Offers. We have written below query to identify the data but it is not clear to pin point which column to look at to identify the abandoned offers and we are stuck proceeding further with the testing.

select m.projected_start_date,r.requisition_number, c.candidate_number, ic.object_status as Offer_Object_Status, s.object_status as Submission_Object_Status, m.effective_start_date, m.Effective_End_Date, m.Assignment_status_type, m.ASSIGNMENT_TYPE, ph.name as Phase_Name, st.name as State_Name