Items with txns

Description

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 Name SQL text Validation
Organization
mp.organization_code=:organization_code
LOV
Assembly
msib.concatenated_segments=:item
LOV