Purpose:
To show how to select one or more values from the parameter.
example: Item number parameter can be run for All
example: Item number parameter can be run for selected item(s).
Prerequisite:
- The report parameter is setup
- LOV is attached to the parameter
Data Model Query:
select * from egp_system_items_b ESI
where (ESI.inventory_item_id IN (:p_item_id) OR 'All' IN (:p_item_id || 'All'))