...
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 ,
...