SELECT DISTINCT BDS.objid, BDS.X_AV_ID_EDS, BDS.X_AV_STATUT_ACT, BDS.X_AV_DATE_EFF,
(SELECT SUBSTR(BDS1.X_AV_LB_DYNAMIC,22)
FROM TABLE_CONTR_ITM BDS1
WHERE BDS1.X_AV_ID_EDS = BDS.X_AV_ID_EDS
AND BDS1.X_AV_LB_DYNAMIC LIKE 'Maintenance et GTR%') AS ""GTR+Plage de Maintenance"",
BDS.END_DATE
FROM TABLE_CONTR_ITM BDS
WHERE BDS.LINE_NO = 0
AND EXISTS (
SELECT *
FROM  TABLE_CONTR_ITM BDS1
    INNER JOIN TABLE_MOD_LEVEL ML
        ON BDS1.contr_itm2mod_level = ML.objid
    INNER JOIN TABLE_PART_NUM BDS_CAT
        ON ML.part_info2part_num = BDS_CAT.objid
WHERE BDS1.X_AV_ID_EDS = BDS.X_AV_ID_EDS
AND BDS_CAT.PART_NUMBER IN ('56373','55742','56386','56381')
);