Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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
Tagged:
0