SQL Query to Extract Loaded Learning Records from Oracle Fusion

 SELECT DISTINCT
hrcik.OBJECT_NAME,
TO_CHAR(warf.EFFECTIVE_START_DATE,'DD/MM/YYYY') AS LearningRecordEffectiveStartDate,
TO_CHAR(warf.EFFECTIVE_END_DATE,'DD/MM/YYYY') AS LearningRecordEffectiveEndDate,
warf.ASSIGNMENT_RECORD_NUMBER AS LEARNING_RECORD_NUMBER,
wleaf.ASSIGNMENT_PROFILE_NUMBER AS ASSIGNMENT_NUMBER,
wlfli.LEARNING_ITEM_TYPE,
wlfli.LEARNING_ITEM_NUMBER,
warf.EVENT_TYPE AS ASSIGNMENT_TYPE,
warf.EVENT_SUB_TYPE AS ASSIGNMENT_SUB_TYPE,
(select distinct person_number from per_all_people_f where person_id = wlfli.OWNED_BY_ID ) ASSIGNED_BY_PERSON_NUMBER,
warf.ATTRIBUTION_TYPE AS ASSIGNMENT_ATTRIBUTION_TYPE,
(select distinct person_number from per_all_people_f where person_id = wlfli.OWNED_BY_ID ) ASSIGNMENT_ATTRIBUTION_NUMBER,
NVL(warf.ATTRIBUTION_LOOKUP_CODE, 'ORA_SELF') AS ASSIGNMENT_ATTRIBUTION_CODE,
papf.PERSON_NUMBER AS "LEARNER_NUMBER",
warf.STATUS AS LEARNING_RECORD_STATUS,
TO_CHAR(warf.EFFECTIVE_START_DATE,'DD/MM/YYYY') "LEARNING_RECORD_START_DATE",
TO_CHAR(warf.CALCULATED_DUE_DATE,'DD/MM/YYYY') "LEARNING_RECORD_DUE_DATE",
TO_CHAR(warf.WITHDRAWN_DATE, 'DD/MM/YYYY') "LEARNING_RECORD_WITHDRAWN_DATE",
TO_CHAR(warf.DELETED_DATE, 'DD/MM/YYYY') "LEARNING_RECORD_DELETED_DATE",
TO_CHAR(warf.COMPLETION_DATE,'DD/MM/YYYY') "LEARNING_RECORD_COMPLETION_DATE",
TO_CHAR(warf.VALIDITY_DATE,'DD/MM/YYYY') "LEARNING_RECORD_VALID_FROM_DATE",
TO_CHAR(warf.EXPIRATION_DATE,'DD/MM/YYYY') "LEARNING_REC_EXPIRY_DATE",
warf.TOTAL_ACTUAL_EFFORT AS "LEARNING_REC_TOT_ACT_EFFORT",
warf.EFFORT_UOM AS "LEARNING_REC_TOT_ACT_EFFORT_UOM",
warf.REASON_CODE AS "LEARNING_RECORD_REASON_CODE",
'DataMigration' "LEARNING_RECORD_COMMENTS",
warf.ACTUAL_SCORE "ACTUAL_SCORE",
hrcik.SOURCE_SYSTEM_OWNER,
hrcik.SOURCE_SYSTEM_ID
FROM
WLF_LEARNING_ITEMS_F wlfli,
HRC_INTEGRATION_KEY_MAP hrcik,
WLF_ASSIGNMENT_RECORDS_F warf,
PER_ALL_PEOPLE_F papf,
WLF_EVENT_ASSIGNMENTS_F wleaf
WHERE 
to_char(warf.LEARNING_ITEM_ID) = to_char(wlfli.LEARNING_ITEM_ID)
AND wlfli.LEARNING_ITEM_ID = hrcik.SURROGATE_ID
AND warf.learner_id = papf.person_id
AND warf.EVENT_ASSIGNMENT_ID = wleaf.EVENT_ASSIGNMENT_ID
AND sysdate BETWEEN papf.EFFECTIVE_START_DATE AND papf.EFFECTIVE_END_DATE
AND hrcik.SOURCE_SYSTEM_OWNER = 'HRC_SQLLDR'
ORDER BY wleaf.ASSIGNMENT_PROFILE_NUMBER