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
CAC Manufacturing Variance Summary CAC Manufacturing Variance Detail CAC WIP Material Usage with Configuration and Lot Variances CAC Calculate ICP PII Item Costs by Where Used CAC Intercompany SO Price List vs. Item Cost Comparison CAC ICP PII Inventory Pending Cost Adjustment CAC Calculate Average Item Costs CAC Inventory to G/L Reconciliation (Restricted by Org Access) CAC Where Used by Cost Type CAC Inventory Pending Cost Adjustment
Blitz Report™

Blitz Report™ provides multiple benefits: