How to get Implemented Revision in the Org for a part number-EBS

To show only "Implemented" revisions (where implementation date is populated) in the Organization and it should be used to populate the revision value.

EBS Query:

SELECT   msi.segment1, MAX (revision)
    FROM mtl_system_items_b msi, mtl_item_revisions mir
   WHERE msi.organization_id = mir.organization_id
     AND msi.inventory_item_id = mir.inventory_item_id
     AND msi.organization_id = &org_id
     AND msi.segment1 = '&item'
     AND mir.implementation_date IS NOT NULL
GROUP BY msi.segment1