The setting COPY EMAIL ADDRESSES should be set to the current product owner on Acceptance and Production. See the script provided below.

--Acceptance and Production
--Update the EMAIL COPY ADDRESSES (an AAIR setting) to current product owner.
UPDATE TR47_CAWIS_GENERAL_PROPS
SET PROPERTY_VALUE = 'GENEVIEVE.BOURGEOIS@TC.GC.CA',
LAST_MOD_TIMESTAMP_DTE = SYSDATE,
LAST_MOD_BY_USER_ID = 'ADMIN'
WHERE      UPPER(PROPERTY_NAME) = UPPER('EMAIL COPY ADDRESSES');

/* Formatted on 2024-02-27 10:41:38 AM (QP5 v5.294) */
  SELECT                                                    --Y02.aircraft_id,
        Y50.CLIENT_ID,
         Y55.NAME_FIRST_NM || ' ' || Y55.NAME_LAST_NM AS OWNER,
         Y56.NAME_COMMON_NM,
         --Existing Address
         --A90.ADDRESS_ID,
         A90.ADDRESS_LINE1_TXT,
         A90.ADDRESS_LINE2_TXT,
         A90.CITY_TXT,
         A90.PROVINCE_CD,
         A90.POSTAL_CODE_ID,
         TR21.COUNTRY_ETXT,
         -- New Address if anything change
         CASE
            WHEN A90.ADDRESS_LINE1_TXT <> A90.ADDRESS_LINE1_UPDATED_TXT
            THEN
               A90.ADDRESS_LINE1_UPDATED_TXT
            WHEN     A90.ADDRESS_LINE1_TXT IS NULL
                 AND TRIM (A90.ADDRESS_LINE1_UPDATED_TXT) IS NOT NULL
            THEN
               A90.ADDRESS_LINE1_UPDATED_TXT
         END
            AS UPDATED_ADDRESS_LINE1,
         CASE
            WHEN A90.ADDRESS_LINE2_TXT <> A90.ADDRESS_LINE2_UPDATED_TXT
            THEN
               A90.ADDRESS_LINE2_UPDATED_TXT
            WHEN     A90.ADDRESS_LINE2_TXT IS NULL
                 AND TRIM (A90.ADDRESS_LINE2_UPDATED_TXT) IS NOT NULL
            THEN
               A90.ADDRESS_LINE2_UPDATED_TXT
         END
            AS UPDATED_ADDRESS_LINE2,
         CASE
            WHEN A90.CITY_TXT <> A90.CITY_UPDATED_TXT
            THEN
               A90.CITY_UPDATED_TXT
            WHEN     A90.CITY_TXT IS NULL
                 AND TRIM (A90.CITY_UPDATED_TXT) IS NOT NULL
            THEN
               A90.CITY_UPDATED_TXT
         END
            AS UPDATED_CITY_TXT,
         CASE
            WHEN A90.PROVINCE_CD <> A90.PROVINCE_UPDATED_CD
            THEN
               A90.PROVINCE_UPDATED_CD
            WHEN     A90.PROVINCE_CD IS NULL
                 AND TRIM (A90.PROVINCE_UPDATED_CD) IS NOT NULL
            THEN
               A90.PROVINCE_UPDATED_CD
         END
            AS UPDATED_PROVINCE_CD,
         CASE
            WHEN A90.POSTAL_CODE_ID <> A90.POSTAL_CODE_UPDATED_ID
            THEN
               A90.POSTAL_CODE_UPDATED_ID
            WHEN     A90.POSTAL_CODE_ID IS NULL
                 AND TRIM (A90.POSTAL_CODE_UPDATED_ID) IS NOT NULL
            THEN
               A90.POSTAL_CODE_UPDATED_ID
         END
            AS UPDATED_POSTAL_CODE,
         CASE
            WHEN A90.COUNTRY_CD <> A90.COUNTRY_UPDATED_CD
            THEN
               TR21U.COUNTRY_ETXT
            WHEN     A90.COUNTRY_CD IS NULL
                 AND TRIM (A90.COUNTRY_UPDATED_CD) IS NOT NULL
            THEN
               TR21U.COUNTRY_ETXT
         END
            AS UPDATED_COUNTRY_CD,
         (SELECT A92.ADDRESS_PROPERTY_TXT
            FROM A92_ADDRESS_PROPERTY A92
           WHERE     A92.ADDRESS_ID = A90.ADDRESS_ID
                 AND A92.ADDRESS_PROPERTY_TYPE_CD = '1'
                 AND A92.ORDINAL_NBR = 1
                 AND A92.Last_Mod_timestamp_dte BETWEEN TO_DATE ('01Dec2023')
                                                    AND TO_DATE ('05Feb2024'))
            AS ADDR_PHONE,
         A92.ADDRESS_PROPERTY_TXT                   AS ADDR_EMAIL,
         A90.Last_Mod_timestamp_dte
    FROM Y50_PARTY Y50
         LEFT JOIN Y90_PARTY_CONTACT Y90 ON Y90.PARTY_ID = Y50.PARTY_ID
         JOIN A90_ADDRESS A90
            ON     A90.ADDRESS_ID = Y90.ADDRESS_ID
               AND A90.Last_Mod_timestamp_dte BETWEEN TO_DATE ('01Dec2023')
                                                  AND TO_DATE ('05Feb2024')
         LEFT OUTER JOIN Y55_INDIVIDUAL Y55 ON Y55.PARTY_ID = Y50.PARTY_ID
         LEFT OUTER JOIN Y56_ORGANIZATION Y56 ON Y56.PARTY_ID = Y50.PARTY_ID
         LEFT JOIN A92_ADDRESS_PROPERTY A92
            ON     A90.ADDRESS_ID = A92.ADDRESS_ID
               AND A92.ADDRESS_PROPERTY_TYPE_CD = '3'
               AND A92.Last_Mod_timestamp_dte BETWEEN TO_DATE ('01Dec2023')
                                                  AND TO_DATE ('05Feb2024')
         LEFT OUTER JOIN TR21_COUNTRY TR21 ON TR21.COUNTRY_CD = A90.COUNTRY_CD
         LEFT OUTER JOIN TR21_COUNTRY TR21U
            ON TR21U.COUNTRY_CD = A90.COUNTRY_UPDATED_CD
   WHERE    TRIM (A90.ADDRESS_LINE1_UPDATED_TXT) IS NOT NULL
         OR TRIM (A90.ADDRESS_LINE2_UPDATED_TXT) IS NOT NULL
         OR TRIM (A90.CITY_UPDATED_TXT) IS NOT NULL
         OR TRIM (A90.COUNTRY_UPDATED_CD) IS NOT NULL
         OR TRIM (A90.POSTAL_CODE_UPDATED_ID) IS NOT NULL
         OR     TRIM (A90.PROVINCE_UPDATED_CD) IS NOT NULL
            AND A90.ADDRESS_ID IN
                   (SELECT Y90.ADDRESS_ID
                      FROM Y02_AIRCRAFT_HISTORY Y02
                           JOIN Y53_PARTY_LIST Y53
                              ON Y53.AIRCRAFT_PARTY_LIST_ID = Y02.AIRCRAFT_ID
                           JOIN Y50_PARTY Y50 ON Y50.PARTY_ID = Y53.PARTY_ID
                           LEFT JOIN Y90_PARTY_CONTACT Y90
                              ON Y90.PARTY_ID = Y50.PARTY_ID
                     WHERE                     --  Y02.AIRCRAFT_ID = 14633 AND
                          NOT   EXISTS
                                  (SELECT 1
                                     FROM Y02_AIRCRAFT_HISTORY Y02a
                                    WHERE     Y02a.AIRCRAFT_ID =
                                                 Y02.AIRCRAFT_ID
                                          AND Y02A.DATE_START_DTE >
                                                 Y02.DATE_START_DTE)
                           AND Y90.ADDRESS_TYPE_CD = '1'
                           AND Y53.DATE_STOP_DTE IS NULL
                           AND Y02.ACTIVE_INACTIVE_IND = 'A'
                           AND Y53.REGISTERED_OWNER_IND = 'Y')
ORDER BY A90.Last_Mod_timestamp_dte DESC;