Items with txns

➜ Back to Library
Description
select msib.* from mtl_system_items_b msib , mtl_material_transactions mmt, mtl_parameters mp
where 1=1
and msib.inventory_item_id = mmt.inventory_item_id
and msib.organization_id = mmt.organization_id
and msib.organization_id = mp.organization_id
Parameter NameSQL textValidation
Organization
mp.organization_code=:organization_code
LOV
Assembly
msib.concatenated_segments=:item
LOV
Download
Related Blitz Reports
TB GL Account Analysis (Drilldown)v2 ECC Project Manufacturing Genealogy & Trace, Project Locators GW-Material Account Distributions GW Material Account Distribution Inventory mad CAC WIP Jobs With Complete Status Which Are Ready for Close CAC Inventory Lot and Locator OPM Value (Period-End) MAD1 GMF MUV Detail GMD MUV Detail
Blitz Report™