...
as OWNER ,
---
TRIM(REPLACE(
Y02.FLEET_ID || ' ' || DECODE(Y02.AIRCRAFT_FRAME_CYCLES_NBR,1,'X',' ‘)
/* 'X’ INDICATES FLEET PROBLEM */
|| (SELECT ' - ' || SUBSTR(TRIM(Y50XX.NOTES_TXT),1,4045)
FROM FROM Y59_FLEET YY, Y50_PARTY Y50, Y59_FLEET Y59 WHERE Y59XX
WHERE YY.FLEET_ID = Y02.FLEET_ID
AND Y50XX.PARTY_ID = Y59YY.PARTY_ID) ,' ',' ')) || ' '
as as FLEET ,
---
REPLACE(
(DECODE(Y93.SALE_REPORTED,'Y','SR','') ||
...