I am working on a report that requires me to use this query

SELECT        Aircraft.ID, Aircraft.AC_SERIAL, Aircraft.TAIL_NUMBER, Aircraft.MISSION, Modl.MODEL_DESCRIPTION, Op.OPERATOR_NAME, Aircraft.IN_SERVICE_DATE, Aircraft.DELIVERY_DATE, Aircraft.LOCATION_ID, 
                         Aircraft.TDY_LOCATION_ID, Aircraft.SCHEDULED_IN_SERVICE_DATE, Aircraft.FINISHING_CTR_DELIVERY_DATE, Aircraft.FINISHING_CTR_DELIVERY_HOURS, Aircraft.PRODUCTION_DATE, Aircraft.OUT_OF_SERVICE_DATE, 
                         Aircraft.STORAGE_DATE, Aircraft.DATE_CREATED,
                             (SELECT        lks.APP_NAME
                               FROM            FMOC.TRAN_AC_AVAILABILITY_EVENT Evs
                                JOIN FMOC.LK_APP_LOOKUP lks ON Evs.STATUS_TYPE_ID = lks.ID
                               WHERE        lks.APP_LOOKUP_TYPE = 'AC_STATUS' AND Evs.AIRCRAFT_ID = Aircraft.ID
                               ORDER BY Evs.EVENT_DATE DESC FETCH FIRST 1 ROW ONLY) AC_STATUS
FROM            FMOC.TRAN_AIRCRAFT Aircraft, FMOC.TRAN_OPERATOR Op, FMOC.LK_AIRCRAFT_MODEL Modl
WHERE        Aircraft.OPERATOR_ID = Op.ID AND Aircraft.MODEL_ID = Modl.ID AND (Aircraft.OUT_OF_SERVICE_IND <> 'Y') AND (Aircraft.RETIRED_DATE IS NULL) AND (Aircraft.DELIVERY_DATE IS NOT NULL) AND Aircraft.FIELD_SVC_REP_CONTACT_ID = :FSR_ID

previously this query had worked on the test data but now on the new database it does not.

I am using oracle database.

I get errors saying commands are incorrect

i tried changing the first row only portion to

SELECT 
    Aircraft.ID, 
    Aircraft.AC_SERIAL, 
    Aircraft.TAIL_NUMBER, 
    Aircraft.MISSION, 
    Modl.MODEL_DESCRIPTION, 
    Op.OPERATOR_NAME, 
    Aircraft.IN_SERVICE_DATE, 
    Aircraft.DELIVERY_DATE, 
    Aircraft.LOCATION_ID, 
    Aircraft.TDY_LOCATION_ID, 
    Aircraft.SCHEDULED_IN_SERVICE_DATE, 
    Aircraft.FINISHING_CTR_DELIVERY_DATE, 
    Aircraft.FINISHING_CTR_DELIVERY_HOURS, 
    Aircraft.PRODUCTION_DATE, 
    Aircraft.OUT_OF_SERVICE_DATE, 
    Aircraft.STORAGE_DATE, 
    Aircraft.DATE_CREATED,
    (SELECT lks.APP_NAME
     FROM (
         SELECT lks.APP_NAME,
                Evs.AIRCRAFT_ID,
                ROW_NUMBER() OVER (PARTITION BY Evs.AIRCRAFT_ID ORDER BY Evs.EVENT_DATE DESC) AS rn
         FROM FMOC.TRAN_AC_AVAILABILITY_EVENT Evs
         JOIN FMOC.LK_APP_LOOKUP lks ON Evs.STATUS_TYPE_ID = lks.ID
         WHERE lks.APP_LOOKUP_TYPE = 'AC_STATUS'
     ) sub
     WHERE sub.AIRCRAFT_ID = Aircraft.ID AND sub.rn = 1) AS AC_STATUS
FROM 
    FMOC.TRAN_AIRCRAFT Aircraft
    JOIN FMOC.TRAN_OPERATOR Op ON Aircraft.OPERATOR_ID = Op.ID
    JOIN FMOC.LK_AIRCRAFT_MODEL Modl ON Aircraft.MODEL_ID = Modl.ID
WHERE 
    Aircraft.OPERATOR_ID = Op.ID 
    AND Aircraft.MODEL_ID = Modl.ID 
    AND (Aircraft.OUT_OF_SERVICE_IND <> 'Y') 
    AND (Aircraft.RETIRED_DATE IS NULL) 
    AND (Aircraft.DELIVERY_DATE IS NOT NULL) 
    AND Aircraft.FIELD_SVC_REP_CONTACT_ID = :FSR_ID;

but i cant seem to get it working in this query.

my guess is the oracle version doesnt accept whatever I originally had