Inventory Listing

➜ Back to Library
Description
Run Inventory Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
select mp.*, 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 = :p_org_code
 LOV
Last Update within Days 
msib.last_update_date>sysdate-:days
 Number
Download
Related Blitz Reports
inventory item tracker PO Overdue Vendor Shipments Inventory mad CAC WIP Jobs With Complete Status Which Are Ready for Close XXEN_SCHUB_ITEM_CUSTOM_QUERY MAD1 CAC Inventory to G/L Reconciliation (Unrestricted by Org Access) new report items GMF MUV Detail GMD MUV Detail
Blitz Report™

Blitz Report™ provides multiple benefits: