select distinct ctp.* 
  from CMD_TASK_PRODUCT ctp 
 where ctp.TASK_ID= 29  and (ctp.IS_INTEREST= 1  or ctp.IS_OFFER= 1  or  ctp.IS_CONTRACT= 1 )

select ctp.* from CMD_TASK_PRODUCT ctp where ctp.TASK_ID= 29  and ctp.IS_INTEREST= 1 :

task_id product_id

 29         3 
 29         4 

select ctp.* from CMD_TASK_PRODUCT ctp where ctp.TASK_ID= 29  and ctp.IS_OFFER= 1 

task_id product_id

 29         2 

select ctp.* from CMD_TASK_PRODUCT ctp where ctp.TASK_ID= 29  and ctp.IS_CONTRACT= 1 

task_id product_id

 29         1 
 29         22 
 29         23 

task_id product_id_interest product_id_offer product_id_contract

 29         3                           2                        1 
 29         4                          null                    22 
 29        null                      null                    23 

with dummy(id) as (
    select  1  from SYSIBM.SYSDUMMY1    
    union all
    select id +  1  from dummy where id < (select get_max_products_for_task( 29 ) from SYSIBM.SYSDUMMY1)
)
select dummy.id, interestTasks.product_id as interestProductId, offerTasks.product_id as offerProductId, contractTasks.product_id as contractProductId from dummy 
left outer join (select ctp.product_id, rownumber() over() as rn from CMD_TASK_PRODUCT ctp where ctp.TASK_ID= 29  and ctp.IS_INTEREST= 1 ) interestTasks on interestTasks.RN=dummy.ID
left outer join (select ctp.product_id, rownumber() over() as rn from CMD_TASK_PRODUCT ctp where ctp.TASK_ID= 29  and ctp.IS_OFFER= 1 ) offerTasks on offerTasks.RN=dummy.ID
left outer join (select ctp.product_id, rownumber() over() as rn from CMD_TASK_PRODUCT ctp where ctp.TASK_ID= 29  and ctp.IS_CONTRACT= 1 ) contractTasks on contractTasks.RN=dummy.ID;