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