Forum Stats

  • 3,825,999 Users
  • 2,260,586 Discussions
  • 7,896,761 Comments

Discussions

SQL query to map Overdue tasks in checklists

User_UOL70
User_UOL70 Member Posts: 1 Green Ribbon

Im trying to pull employees allocated checklists overdue tasks in BI Publisher. I am lookin at these tables, PER_ALLOCATED_CHECKLISTS and PER_ALLOCATED_TASKS however I am unable to find any fields related to Overdue or Due Date. Although when I check on the configuration of the lookups ORA_PER_CHK_FILTER_DUE_DATE under Checklist Templates module. I am unable to find which table and field to use in order to map this and get the values? Any advise.

Tagged: