Demo Hub

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 ...
check items last updated in the last X number of days
select msib.*, mp.*
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
mp.organization_code=:organization_code
LOV
Last Update within Days
msib.last_update_date>sysdate-:days
Number