Learn Module | SQL query to get specialization details , module name, offering name, enrolled learne

Content

Hi All,

I am working on a report where I need to fetch specialization details and its' corresponding module name, offering name, enrolled learners, current status of offering, enrollment date.

I have a query where I am able to fetch offering name, enrolled learners name, current status of offering.

I have a query where I am able to fetch specialization name.

I need input to get the above details in a single query.

I need input to establish a link between the three separate queries.

 

Code Snippet

/* Offering Details Code*/

select
WLFI.LEARNING_ITEM_NUMBER
,TO_CHAR(WLFI.EFFECTIVE_START_DATE,'YYYY/MM/DD') Offer_Eff_Start_Dt
,WLFT.NAME

,WLFI.LI_START_DATE Offer_Start_Date

,PPNF.FULL_NAME  EMPLOYEE_NAME
,PPSL.PERSON_NUMBER
,COURSE_NAME.NAME AS COURSE
,WLFI.STATUS 


FROM 
WLF_LEARNING_ITEMS_F WLFI,
WLF_LI_COURSES_F WLCF,
WLF_LI_CLASSES_F WLCLF,
WLF_LEARNING_ITEMS_F_TL WLFT,
PER_PERSON_SECURED_LIST_V PPSL,
WLF_ASSIGNMENT_RECORDS_F ASSGT,
PER_PERSON_NAMES_F PPNF,
(SELECT LIF1.NAME,
        LCF.LEARNING_ITEM_ID
        FROM   WLF_LEARNING_ITEMS_F_VL LIF1,
               WLF_LI_CLASSES_F LCF
        WHERE  LIF1.LEARNING_ITEM_ID = LCF.COURSE_LEARNING_ITEM_ID
               AND TRUNC(SYSDATE) BETWEEN LIF1.EFFECTIVE_START_DATE AND