2213: end if;
2214: SELECT 'valid'
2215: INTO l_dummy
2216: FROM mtl_customer_items citems
2217: ,mtl_customer_item_xrefs cxref
2218: ,mtl_system_items_vl sitems
2219: WHERE citems.customer_item_id = cxref.customer_item_id
2220: AND cxref.inventory_item_id = sitems.inventory_item_id
2221: AND sitems.inventory_item_id = p_inventory_item_id