Requisition Report data not match with fusion job requisition data(attached screenshot)

Summary:

Requisition Report not match with fusion job requisition

Content (please ensure you mask any confidential information):

In the below SQL code for requisition count not match with fusion job requisition count value.

Below is the SQL :

SELECT
COUNT(DISTINCT irvl.Requisition_Number) AS C
FROM
irc_requisitions_vl irvl,
PER_LEGAL_EMPLOYERS PLE
WHERE 1=1
AND IRVL.ORGANIZATION_ID IS NOT NULL
AND IRVL.RECRUITER_ID IS NOT NULL
AND IRVL.HIRING_MANAGER_ID IS NOT NULL
AND IRVL.BUSINESS_UNIT_ID IS NOT NULL
AND PLE.ORGANIZATION_ID = IRVL.LEGAL_EMPLOYER_ID(+)

This query return 1715 number of data but in the job requisition (attached in the screenshot) have 1430 number of data.