10299: SELECT mcr.inventory_item_id
10300: , mcr.uom_code
10301: , mir.revision
10302: FROM mtl_cross_references mcr
10303: , mtl_item_revisions mir
10304: WHERE mcr.organization_id = mir.organization_id (+)
10305: AND mcr.inventory_item_id = mir.inventory_item_id (+)
10306: AND mcr.revision_id = mir.revision_id (+)
10307: AND mcr.cross_reference_type = p_ref_type