Reports (BIP) – Offering Details Query

select
WLFI.LEARNING_ITEM_NUMBER
,WLFI.LEARNING_ITEM_ID
,TO_CHAR(WLFI.EFFECTIVE_END_DATE,'YYYY/MM/DD') "Offering Effective End Date"
,TO_CHAR(WLFI.EFFECTIVE_START_DATE,'YYYY/MM/DD') "Offering Effective Start Date"
,WLFT.NAME
,WLCLF.MAXIMUM_ATTENDEES
,WLCLF.MINIMUM_ATTENDEES
,TO_CHAR(WLCLF.ENROLMENT_END_DATE,'YYYY/MM/DD') "Offering Enrollment End Date"
,TO_CHAR(WLCLF.ENROLMENT_START_DATE,'YYYY/MM/DD') "Offering Enrollment Start Date"
,WLCLF.DELIVERY_MODE
,TO_CHAR(WLFI.END_DATE,'YYYY/MM/DD') "Offering Publish End Date"
,TO_CHAR(WLFI.START_DATE,'YYYY/MM/DD') "Offering Publish Start Date"
,TO_CHAR(WLFI.LI_START_DATE,'YYYY/MM/DD') "Offering Start Date"
,TO_CHAR(WLFI.LI_END_DATE,'YYYY/MM/DD') "Offering End Date"
FROM WLF_LEARNING_ITEMS_F WLFI,
WLF_LI_COURSES_F WLCF,
WLF_LI_CLASSES_F WLCLF,
WLF_LEARNING_ITEMS_F_TL WLFT
WHERE
WLFI.LEARNING_ITEM_ID = WLFT.LEARNING_ITEM_ID
AND WLFI.LEARNING_ITEM_ID = WLCLF.LEARNING_ITEM_ID
AND WLCLF.COURSE_LEARNING_ITEM_ID = WLCF.LEARNING_ITEM_ID
AND WLFT.LANGUAGE(+) = 'US'
AND WLFI.EFFECTIVE_START_DATE BETWEEN WLFT.EFFECTIVE_START_DATE AND WLFT.EFFECTIVE_END_DATE
AND WLFI.EFFECTIVE_END_DATE BETWEEN WLFT.EFFECTIVE_START_DATE AND WLFT.EFFECTIVE_END_DATE
AND WLFI.LEARNING_ITEM_TYPE = 'ORA_CLASS'
AND WLFI.LEARNING_ITEM_NUMBER = 'OLC245030'