انا باشتغل على query بالشكل ده

select sum(a.TRANSACTION_QUANTITY),b.SEGMENT1,b.DESCRIPTION||'/'||b.attribute20||'/'||b.attribute30||'/'||b.attribute5,a.SUBINVENTORY_CODE,b.PRIMARY_UOM_CODE
from mtl_material_transactions a,mtl_system_items b
where a.organization_id=105
and 
(b.description like '%'||:p1||'%'
or b.ATTRIBUTE20 like '%'||:p2||'%'
or b.ATTRIBUTE30 like '%'||:p3||'%'
or b.ATTRIBUTE5 like '%'||:p4||'%')
and a.INVENTORY_ITEM_ID=b.INVENTORY_ITEM_ID
and a.ORGANIZATION_ID=b.ORGANIZATION_ID
group by b.SEGMENT1,b.DESCRIPTION,a.SUBINVENTORY_CODE,b.PRIMARY_UOM_CODE,b.attribute20,b.attribute30,b.attribute5
order by b.description as

انا عندى اربع باراميتر عايز لما واحد فيهم يبقى فاضى الاستعلام يتجاهله ويدور فى الباراميتر التانى لانه المشكلة انه لما بسيب باراميتر فاضى بيجيب كل حاجة والنتيجة كمان
ارجو المساعدة

 

try with this

where a.organization_id=105 
and (b.description like '%'||:p1||'%' or :p1 is null)
and (b.ATTRIBUTE20 like '%'||:p2||'%' or :p2 is null)
and (b.ATTRIBUTE30 like '%'||:p3||'%' or :p3 is null)
and (b.ATTRIBUTE5 like '%'||:p4||'%'  or :p4 is null)
and a.INVENTORY_ITEM_ID=b.INVENTORY_ITEM_ID 
and a.ORGANIZATION_ID=b.ORGANIZATION_ID 

شكرا جدا