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.
...
1)get a list of all inspections against a that specific aircraft,
2) identify the bad record,
...
SELECT SUBSTR(TO_CHAR(C07.AIRCRAFT_ID),1,8) AS ACID,
SUBSTR(Y02.AIRCRAFT_MARK_ID,1,4) AS MRK,
TO_CHAR(Y53.DATE_START_DTE,'YYYY-MM-DD') AS OWNER_START,
SUBSTR(GET_PARTY_INFO(Y53.PARTY_ID),1,25) AS OWNER,
TO_CHAR(DATE_INSPECT_DTE,'YYYY-MM-DD') AS INSPECTION_DATE,
SUBSTR(INSPECTED_BY_CD ,1,1) AS INBY, – (AMO OR AME)
SUBSTR(TRIM(INSPECTOR_AME_LICENSE_NUMBER_I ||
INSPECTOR_AMO_LICENSE_NUMBER_I ),1,12) || ' ' AS LICENSE_NO, --- (AMO OR AME number)
SUBSTR(INSPECTOR_NAME_OTHER_NM,1,25) AS WHO_INSPECTED
FROM C07_AIRCRAFT_INSPECTION C07 ,
...
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 ( 'FBQJXXXX')) /* 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 = XXXXXXIN (SELECT AIRCRAFT_ID FROM Y93_CCARCS_PREVIOUS_DAY WHERE MARK IN ( 'XXXX'))
AND TO_CHAR(DATE_INSPECT_DTE,'YYYY-MM-DD') = 'XXXX-XX-DD';
...