items

Description
Columns: Inventory Item Id, Organization Id, Last Update Date, Last Updated By, Creation Date, Created By, Last Update Login, Summary Flag, Enabled Flag, Start Date Active ...
select msib.*
from mtl_system_items_b msib, mtl_parameters mp
where 1=1
and mp.organization_id=msib.organization_id
Parameter Name SQL text Validation
Organization Code
mp.organization_code=:organization_code
LOV
Item
msib.item_name=:item
LOV
Last Update within Days
msib.last_update_date >sysdate-:days
Number