Value Set – Table Value set to get list of courses
| *FROM Clause | wlf_learning_items_f wlif, wlf_learning_items_f_tl wlift |
| Value Attributes Table Alias | |
| *Value Column Name | SUBSTR(wlift.name,1,150) |
| Value Column Type | VARCHAR2 |
| Value Column Length | 150 |
| Description Column Name | |
| Description Column Type | |
| Description Column Length | |
| ID Column Name | TO_CHAR(wlif.LEARNING_ITEM_ID) |
| ID Column Type | VARCHAR2 |
| ID Column Length | 40 |
| Enabled Flag Column Name | |
| Start Date Column Name | |
| End Date Column Name | |
| WHERE Clause | wlif.LEARNING_ITEM_ID = wlift.LEARNING_ITEM_ID AND wlift.language = ‘US’ AND wlif.LEARNING_ITEM_TYPE = ‘ORA_COURSE’ AND TRUNC(SYSDATE) BETWEEN wlif.effective_start_date and wlif.effective_end_date AND wlif.effective_start_date BETWEEN wlift.effective_start_date and wlift.effective_end_date |
| ORDER BY Clause |