411: --
412: and exists
413: (
414: select 'Component is a Warranty' 415: from mtl_system_items mtl 416: where mtl.organization_id = p_organization_id
417: and mtl.inventory_item_id = bic.component_item_id
418: and mtl.vendor_warranty_flag = 'Y'
419: )