RWB Report Conditions

select
rr.report_name,
rrp.parameter_name,
rrc.*
from
rx_reports rr,
rx_report_conditions rrc,
rx_report_parameters rrp
where
1=1 and
rr.report_id=rrc.report_id and
decode(rrc.parameter2_type,'P',rrc.parameter2_id)=rrp.parameter_id(+)

select rr.report_name, rrp.parameter_name, rrc.* from rx_reports rr, rx_report_conditions rrc, rx_report_parameters rrp where 1=1 and rr.report_id=rrc.report_id and decode(rrc.parameter2_type,'P',rrc.parameter2_id)=rrp.parameter_id(+)