Unable to Identify Join Between WLF_LI_ACTIVITIES_F and HRQ_QUESTIONNAIRES_B for Evaluation Details
in Learning
Summary:
We need to retrieve evaluation details in our report. We are able to identify the evaluation records in the WLF_LI_ACTIVITIES_F table where the ACTIVITY_TYPE = 'ORA_DEF_QUESTIONNAIRE'. Additionally, we can access the questionnaire details in the HRQ_QUESTIONNAIRES_B table.
As shown in the screenshot, the evaluation details include a highlighted field that appears to be linked to the questionnaire name. However, we are unable to identify the correct join or linking table between WLF_LI_ACTIVITIES_F and HRQ_QUESTIONNAIRES_B.
Could you please help us identify the appropriate table or join condition to link these two tables?
Tagged:
0