4180: and inventory_item_id = gt.inventory_item_id
4181: and uom.uom_code = gt.uom_code
4182: union
4183: select 'X'
4184: from mtl_units_of_measure uom
4185: where sysdate <= nvl(trunc(uom.disable_date), sysdate)
4186: and gt.inventory_item_id is null
4187: and gt.uom_code = uom.uom_code);
4188: