Purge task is missing
Summary: We are creating a report to fetch archived and purged tasks details , after purging the checklist , task name are missing .
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
SELECT distinct pcaa.ALLOCATED_CHECKLIST_ID,
PAPF.PERSON_NUMBER,
PPNF.DISPLAY_NAME AS "Full Name",
PCT.NAME AS CHECKLIST_NAME,
(select PCATL.TASK_NAME
from PER_CHK_ARCH_ALLOC_TASKS_TL pcatl
where
PCATL.ALLOCATED_TASK_ID = PCAT.ALLOCATED_TASK_ID
and ROWNUM = 1
) as TASK_NAME,
PCAA.CHECKLIST_CATEGORY,
--PCAA.CHECKLIST_INSTANCE,
--(SELECT HL.MEANING FROM HCM_LOOKUPS HL WHERE HL.LOOKUP_CODE = PCAT.status AND HL.LOOKUP_TYPE = 'PER_CHECKLIST_TASK_STATUS') AS TASK_COMPLETION_STATUS,