This is a frequent request from the publications unit
See PBI #115120
The 5008 page and the AAIR entry page will ONLY display the inspection data for the most recent inspection.
Operators frequently enter an incorrect date, due to calendar issues on various browsers.
The 5008 requires a Grid displaying all inspections, so that the TC User can delete incorrect rows, then re-enter proper dates
For now, to deal with this issue,
get a list of all inspections against a specific aircraft,
identify the bad record,
delete the bad record
return the request to the user, They may need to enter any “missing” inspect dates
-- REVIEW ALL INSPECT RECORDS FOR THAT TAIL MARK, 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,
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 ,
Y53_PARTY_LIST Y53,
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 ( 'FBQJ'))
AND C07.INSPECTION_TYPE_CD = 2
ORDER BY Y02.AIRCRAFT_MARK_ID, C07.DATE_INSPECT_DTE DESC;
– DELETE bad record from C07_AIRCRAFT_INSPECTION
DELETE FROM C07_INSPECTION
WHERE AIRCRAFT_ID = XXXXXX
AND TO_CHAR(DATE_INSPECT_DTE,'YYYY-MM-DD') = 'XXXX-XX-DD';
0 Comments