Oracle ERP Professionals

-----Query to Get OLM Employee Information----------

SELECT
P.EMPLOYEE_NUMBER,
AVT.VERSION_NAME COURSE_NAME,
E.TITLE CLASS_NAME,
E.COURSE_START_DATE,
E.COURSE_END_DATE,
E.EVENT_TYPE,
O.SUCCESSFUL_ATTENDANCE_FLAG,
OB.NAME STATUS,
E.TIMEZONE
--E.EVENT_ID,
--O.EVENT_ID,
--P.EFFECTIVE_START_DATE,
--P.EFFECTIVE_END_DATE,
FROM
APPS.PER_ALL_PEOPLE_F P,
APPS.OTA_DELEGATE_BOOKINGS O,
APPS.OTA_EVENTS E,
APPS.OTA_BOOKING_STATUS_TYPES OB,
APPS.OTA_ACTIVITY_VERSIONS AVT
WHERE 1=1
AND O.DELEGATE_PERSON_ID = P.PERSON_ID
AND E.EVENT_ID = O.EVENT_ID
AND OB.BOOKING_STATUS_TYPE_ID = O.BOOKING_STATUS_TYPE_ID
AND E.ACTIVITY_VERSION_ID = AVT.ACTIVITY_VERSION_ID
AND SYSDATE BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE
AND P.EMPLOYEE_NUMBER = 200646
--AND AVT.LANGUAGE = USERENV('LANG')
--AND E.LANGUAGE = USERENV('LANG')