SELECT DISTINCT wip_requirement_operations.inventory_item_id,

wip_requirement_operations.quantity_issued,
wip_requirement_operations.segment1,
wip_entities.wip_entity_name, mtl_system_items_b.description,
( ( wip_requirement_operations.quantity_issued
/ wip_discrete_jobs.start_quantity
)
* ( wip_discrete_jobs.start_quantity
- wip_discrete_jobs.quantity_completed
)
) job_order_re_qty
FROM wip.wip_requirement_operations, wip.wip_entities,
inv.mtl_system_items_b,
wip.wip_discrete_jobs
WHERE ( (wip_discrete_jobs.status_type <> 7) AND (wip_entities.wip_entity_id = wip_requirement_operations.wip_entity_id
) AND (mtl_system_items_b.segment1 = wip_requirement_operations.segment1
) AND (wip_discrete_jobs.wip_entity_id = wip_requirement_operations.wip_entity_id
)
) and wip_requirement_operations.segment1=nvl(_segment1,wip_requirement_operations.s
egment1)
[or wip_entities.wip_entity_name =nvl(:angry:_wip_entity_name ,wip_entities.wip_entity_name)

فى اخر باراميتر الذى يبدى ب or لا يستدعى البيانات و لكن اذا تم تغير الor ب and يعطى بيانات اريد انا استدى اى براميتر الاول او الثانى و لكن اذا استدعيت باباراميتر و احد لا يعطى بيانات اريد ان استدى بالباراميتر الاول او الثانى او الاثنين معا
و لكم جزيل الشكر اخواتى الاعزاء

الله يهديك لو خليت الكود داخل التاق

SELECT DISTINCT wip_requirement_operations.inventory_item_id,
wip_requirement_operations.quantity_issued,
wip_requirement_operations.segment1,
wip_entities.wip_entity_name, mtl_system_items_b.description,
( ( wip_requirement_operations.quantity_issued
/ wip_discrete_jobs.start_quantity
)
* ( wip_discrete_jobs.start_quantity
- wip_discrete_jobs.quantity_completed
)
) job_order_re_qty
FROM wip.wip_requirement_operations, wip.wip_entities,
inv.mtl_system_items_b,
wip.wip_discrete_jobs
WHERE ( (wip_discrete_jobs.status_type <> 7) AND (wip_entities.wip_entity_id = wip_requirement_operations.wip_entity_id
) AND (mtl_system_items_b.segment1 = wip_requirement_operations.segment1
) AND (wip_discrete_jobs.wip_entity_id = wip_requirement_operations.wip_entity_id
)
) and wip_requirement_operations.segment1=nvl(_segment1,wip_requirement_operations.s
egment1)
[or wip_entities.wip_entity_name =nvl(_wip_entity_name ,wip_entities.wip_entity_name)

جرب
تخليهم في قوس
بعد اخر AND

(wip_requirement_operations.segment1=nvl(_segment1,wip_requirement_operations.s
egment1) or wip_entities.wip_entity_name =nvl(_wip_entity_name ,wip_entities.wip_entity_name) )

SELECT DISTINCT wip_requirement_operations.inventory_item_id,
wip_requirement_operations.quantity_issued,
wip_requirement_operations.segment1,
wip_entities.wip_entity_name, mtl_system_items_b.description,
( ( wip_requirement_operations.quantity_issued
/ wip_discrete_jobs.start_quantity
)
* ( wip_discrete_jobs.start_quantity
- wip_discrete_jobs.quantity_completed
)
) job_order_re_qty
FROM wip.wip_requirement_operations, wip.wip_entities,
inv.mtl_system_items_b,
wip.wip_discrete_jobs
WHERE ( (wip_discrete_jobs.status_type <> 7) AND (wip_entities.wip_entity_id = wip_requirement_operations.wip_entity_id
) AND (mtl_system_items_b.segment1 = wip_requirement_operations.segment1
) AND (wip_discrete_jobs.wip_entity_id = wip_requirement_operations.wip_entity_id
)
) and (wip_requirement_operations.segment1=nvl(_segment1,wip_requirement_operations.s
egment1) or (wip_entities.wip_entity_name =nvl(_wip_entity_name ,wip_entities.wip_entity_name)))