This is a frequent request from the publications unit
See PBI #115120 - As of February 2022, all inspection data was included on the 5008 page in a grid format which allows the user to add, delete, correct any bad data. The directions below are retained for backup purposes only
####################
The 5008 page and the AAIR entry page will ONLY display the inspection data for the most recent inspection.
...
Y02_AIRCRAFT_HISTORY Y02
WHERE Y53.AIRCRAFT_PARTY_LIST_ID = C07.AIRCRAFT_ID
AND Y02.AIRCRAFT_ID = C07.AIRCRAFT_ID
AND Y02.RUN_ID = 99
AND Y53.DATE_STOP_DTE IS NULL
AND C07.AIRCRAFT_ID IN (SELECT AIRCRAFT_ID FROM Y93_CCARCS_PREVIOUS_DAY WHERE MARK IN ( 'XXXX')) /* WHERE XXXX IS THE DESIRED AIRCRAFT TAIL MARK */
AND C07.INSPECTION_TYPE_CD = 2
/* WE ONLY REPAIR TYPE 2. TYPE 1 IS TC INSPECTION - AND IS FIXABLE ONSCREEN */
ORDER BY Y02.AIRCRAFT_MARK_ID, C07.DATE_INSPECT_DTE DESC ;
...
DELETE FROM C07_INSPECTION
WHERE AIRCRAFT_ID IN (SELECT AIRCRAFT_ID = XXXXXXFROM Y93_CCARCS_PREVIOUS_DAY WHERE MARK IN ( 'XXXX'))
AND TO_CHAR(DATE_INSPECT_DTE,'YYYY-MM-DD') = 'XXXX-XX-DD';
...