OTBI To fetch the Requisition Numbers

Summary:

I have a requirement to fetch the Recruitment Number & Recruiter Full Name .
The Subject Areas used ( Individually)
1. Recruiting - Recruiting Real Time
2. Recruiting - Recruiting Event Real Time


The Results pulled through OTBI differs when compared to UI .

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

26A (11.13.26.01.0)

Code Snippet (add any code snippets that support your topic, if applicable):

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT DISTINCT
"Job Requisition - Basic Information"."Requisition Number" saw_0,
"Job Requisition - Hiring Team"."Recruiter Full Name" saw_1
FROM "Recruiting - Recruiting Real Time"