Purge Load Denormalized Tables
Purge Load Denormalized Tables is initiated from the Supplementary Purge using Request Type "PLD".
This function will remove entries in MBOL_DENORM and LOAD_TENDER_DENORM tables.
Identify and delete all the entities that need to be purged, as follows:
- Identify all entries in MBOL_DENORM table with a Planned Ship Date less than or equal to the user specified Cut-Off Date
- Identify all entries in LOAD_TENDER_DENORM table with a Tendered on Date less than or equal to the user specified Cut-Off Date
See Also