inventory item tracker

Description
Run inventory item tracker and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Blitz Report™