Auto Assignment Schedule Generation Detail Log
Auto Assignment Schedule Generation Detail Log
- Archive or Purge
- Purge
- Commit Type (Default)
- ALL_OR_NOTHING
- Commit Parameters (Default)
- Default Purge Aging Days
- 60 days
- Tables affected
- AS_SCHEDULE_RESULT_LOG
- Description/Notes
-
Removes all Auto Assignment Schedule Generation Detail logs. This process involves removing:
- All data from the AS_SCHEDULE_RESULT_LOG table where SKD_ID in (SELECT SKD_ID from SO_SCHEDULE WHERE SKD_GEN_DATE < #WBAP_AGING_DATE#).