--How to check which Integration-tasks contains map stages and map-loader stages in debug mode ?

Run the SQL request below:

select distinct O.FRM_OBJ_OID, O.FRM_OBJ_LOG_NAME, O.FRM_OBJ_MOD_FOLDER, O.FRM_OBJ_MOD_USR, O.FRM_OBJ_MAJOR_MOD_DATE
from FRM_OBJ O,
((select
 distinct SC.XIB_SERVERTASK_OID
 from XIB_STAGE_CONFIG SC, XIB_STAGELOADER_CONFIG SLC
 where
   SC.XIB_STAGE_CONFIG_OID = SLC.XIB_STAGE_CONFIG_OID
   and
     SC.XIB_STAGE_CONFIG_DEBUG = '1'
)
   union
(    
   select
     distinct SC.XIB_SERVERTASK_OID
     from XIB_STAGE_CONFIG SC, XIB_STAGEDML_CONFIG SDC
     where
       SC.XIB_STAGE_CONFIG_OID = SDC.XIB_STAGE_CONFIG_OID
     and
       SC.XIB_STAGE_CONFIG_DEBUG = '1'
)) C
where O.FRM_OBJ_OID = C.XIB_SERVERTASK_OID;