APPS.EAM_RES_USAGE_VALIDATE_PVT dependencies on MTL_SERIAL_NUMBERS

Line 186: from mtl_serial_numbers msn, bom_resource_equipments bre

182: if (p_eam_res_usage_rec.serial_number is not NULL) then
183:
184: select count(*)
185: into g_dummy
186: from mtl_serial_numbers msn, bom_resource_equipments bre
187: where msn.inventory_item_id = bre.inventory_item_id
188: and msn.current_organization_id = bre.organization_id
189: and bre.instance_id = p_eam_res_usage_rec.instance_id
190: and msn.serial_number = p_eam_res_usage_rec.serial_number;