setup of items

➜ Back to Library
Description
Run setup of items 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 Code 
mp.organization_code=:organization_code
 LOV
Last Update within Days 
msib.last_update_date>sysdate-:days
 Number
Download
Related Blitz Reports
inventory item tracker OPM WIP Value ONT Order Discount Detail CST Inventory Value Report - by Cost Group PO Overdue Vendor Shipments Inventory mad CAC WIP Jobs With Complete Status Which Are Ready for Close MAD1 GMF MUV Detail GMD MUV Detail
Blitz Report™

Blitz Report™ provides multiple benefits: