select da.act_year||' - '|| da.act_number act_id,da.pipe_number,DA.DIAMETER,da.wall,
da.steel,da.pipe_length pipe_len,da.pipe_weigth pipe_wei,
da.pipe_year,sr.id||' - '||sr.select_description prich_perev, act_date,smena, da.dpr_confirm, da.dpr_note,
(select FIO from intershop.auth_users where user_name = REGEXP_REPLACE(master_id, '^.*\', null) and rownum = 1) FIO_Master,
(select FIO from intershop.auth_users where user_name = REGEXP_REPLACE(inspector_id, '^.*\', null) and rownum = 1) FIO_Inspector,
(select FIO from intershop.auth_users where user_name = REGEXP_REPLACE(dpr_id, '^.*\', null) and rownum = 1) FIO_Dpr
from DEFECT_ACTS da
left join Sel_Rjs2 sr on da.id_prich_perev = sr.ID
where DA.EDIT_STATE = 0 and
 (da.act_number >= :act_begin or :act_begin1 is null)and
 (da.act_number <= :act_end or :act_end1 is null)and
 (da.Diameter = :diam or :diam1 is null)and
 (da.wall = :wall or :wall1 is null)and
 (da.id_prich_perev = :prich_perev or :prich_perev1 is null)and
 (da.act_year = :act_year_ or :act_year_1 is null)
and
 da.act_date between :DATA_START and :DATA_END and

 (da.pipe_number = :p_n or :p_n1 is null)and
 (da.pipe_year = :p_e or :p_e1 is null)and
  sr.dpr_sign_in_acts = :signature and
 if :signature_status = 1 || :signature_status = 2
 then da.dpr_confirm = :signature_status
 elsif :signature_status = 3
 then da.dpr_note = :signature_status
 order by act_number desc

ORA-00907: отсутствует правая скобка
00907. 00000 -  "missing right parenthesis"
*Cause:
*Action:
Error at Line: 22 Column: 24